backward filter and many to many relationship
Yacoubi
I have been really struggling with this for the past week. Let me explain what is it that I'm trying to do and maybe you can help:
- A forecast is made for 1 product only. It has a date and volume to be ordered
- A product can have many forecasts
- Each product is made out of many intermediates (ingredients) using percentages totaling to 100%: Example: product A = 15% intermediate 1 + 45% intermediate 2 + 40% intermediate 3
How can I create a table or chart showing the following:
monthly volumes for each intermediate (intermediate volume = product volume x intermediate percent for that product)
Below is a snapshot of my current Power BI schema:
Yacoubi
I've finally found the answer: Below is the schema: enter image description here
I've created two meausres. The first one in the "PRODUCT" table named "Product Volume": Product Volume = CALCULATE(SUM(FORECAST[Volume]))
The 2nd is in the "RECIPE" table named "Intermediate Volume": Intermediate Volume = IF ( HASONEVALUE ( INTERMEDIATE[IID] ), SUMX ( RECIPE, RECIPE[Percent] * 'PRODUCT'[Product Volume] ), BLANK() )
And this worked perfectly.
この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。
侵害の場合は、連絡してください[email protected]
編集
関連記事
Related 関連記事
- 1
SQL Server : how can I filter a many to many relationship with delimiter
- 2
Many to many relationship CRUD in Room
- 3
Many-to-many relationship as list
- 4
Power Pivot Many to Many Relationship
- 5
View Many to Many Relationship in laravel
- 6
Querying a many to many relationship in SQL
- 7
Convert existing many to many to reverse many to many relationship using XSLT
- 8
Creating one to many relationship with pivot table of many to many relationship
- 9
Django query filter many to many to many etc
- 10
Laravel save / update many to many relationship
- 11
Friendship system with Laravel : Many to Many relationship
- 12
How to handle Many to Many relationship in mongoDB?
- 13
SQL: many-to-many relationship and the 'ALL' clause
- 14
Postgres many to many relationship on same base table
- 15
Many to many relationship with cascade or set null delete?
- 16
Laravel One to Many of One to Many relationship
- 17
Adding to a Many to Many relationship given primary keys
- 18
Doctrine 2 Many To Many follower relationship not working
- 19
Many to many relationship to delete using annotations
- 20
Symfony Many to Many relationship Persistent collection
- 21
Additional fields in a many-to-many relationship
- 22
Hibernate - Many to many relationship: relationship table not getting populated
- 23
SQL Joins . One to many relationship
- 24
Django query in One to Many relationship
- 25
Django query in One to Many relationship
- 26
Realm one to many relationship not persisted
- 27
One-to-many relationship in gatsby
- 28
One to many relationship CoreData Swift
- 29
Ef core 5 many to many filter
コメントを追加