Exclude columns in matrix from dimensional table

[joshua1990]

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?

[v-yadongf-msft]

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]

@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]

No ideas?