topic Re: Exclude columns in matrix from dimensional table in DAX Commands and Tips

Exclude columns in matrix from dimensional table

joshua1990 — Mon, 17 Oct 2022 13:03:48 GMT

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 — Tue, 18 Oct 2022 06:49:53 GMT

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 — Tue, 18 Oct 2022 09:07:33 GMT

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 — Thu, 20 Oct 2022 12:15:54 GMT

No ideas?