Exclude columns in matrix from dimensional table

joshua1990 · ‎10-17-2022

Hi experts!

I have a table that lists all articles (Article):

Then I have a table that lists all necessary production steps (Routing) for each article:

Both tables are linked by column Article.

Then I have a table (Production) that shows me the production step status:

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 · ‎10-17-2022

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 · ‎10-18-2022

@v-yadongf-msft : Thanks for your support.

In the end a matrix should be displayed in this way:

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 · ‎10-20-2022

No ideas?

Helpful resources