Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
13 |
User | Count |
---|---|
91 | |
85 | |
46 | |
28 | |
21 |