Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi experts!
I have a table that lists all articles (Article):
Article | Date | Value |
A | 01.01.2022 | 500 |
B | 01.01.2022 | 600 |
C | 01.01.2022 | 400 |
Then I have a table that lists all necessary production steps (Routing) for each article:
Article | Process Step | Description |
A | 01 | String |
A | 02 | String |
A | 03 | String |
Both tables are linked by column Article.
Then I have a table (Production) that shows me the production step status:
Article | Order Nr | Process Step |
A | 1 | 01 |
A | 1 | 02 |
B | 2 | 01 |
This table contains just process steps that are finished or started.
This table is linked by Article with the first table (Article).
Now I would like to show all necessary process steps (Routing) in a matrix as a column.
But just all process steps that are already part of table Production or planned process steps out of Routing.
In the end I have a simple Measure like this in values:
IF([Value]="", 0, [Value])
But this measure would display all process steps in column, regardless if it is a defined process step for the article.
How can I exclude columns / process steps that are not part of the selected rows / articles?
Hi @joshua1990 ,
Can you tell me what is your expected output?
Thanks for your efforts & time in advance.
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-yadongf-msft : Thanks for your support.
In the end a matrix should be displayed in this way:
Article | Order | Process Step 01 | Process Step 02 | Process Step 03 | Process Step 04 |
A | 1 | 50 | 50 | 0 | 50 |
B | 2 | 50 | 50 | 50 | 0 |
In columns we have Process Step XX.
But here I would like to exclude all Process Steps that are not part of Tabl Routing and the selected Articles.
Just necessary / applicable Process Steps should be displayed.
No ideas?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
51 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
75 | |
58 | |
47 | |
16 | |
12 |