Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
3 years ago

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's avatar
    v-yadongf-msft
    Icon for Community Support rankCommunity 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's avatar
      joshua1990
      Icon for Post Prodigy rankPost 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.