Forum Discussion
Exclude columns in matrix from dimensional table
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?
3 Replies
- v-yadongf-msft
Community Support
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.
- joshua1990
Post Prodigy
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.
- joshua1990
Post Prodigy
No ideas?