Secondary Table Logic - Dax Calculation Filter

DAX DAX Calculations
1

Hi Guys,

I’m unable to post my PBIX file as it’s so huge and there’s data init that I cannot share so apologies.

Basically, I am having a mental block I think, I have created grouping via a secondary table which works fine when I put it as part of its own visual table as shown below with columns Aged Stock, Fast Moving & Slow Moving.

My challenge is I want just the fast-moving column in the other visual so I want to create a filter against my DAX formula for the grouping to just show me the fast-moving and get that column in the top matrix visual table.

My DAX code is here for the secondary table logic where do i place the filter to show me just the fast-moving result?

Total Stock Value Segmented By Speed = 
CALCULATE([Stock Value (MM60)],
Filter( VALUES('Material Data' ),
    COUNTROWS(
        FILTER('Issuance Speed Support Table',
        [Count Days Between Last Production Issance Date & Today] >= 'Issuance Speed Support Table'[Min] &&
        [Count Days Between Last Production Issance Date & Today] < 'Issuance Speed Support Table'[Max] ) ) > 0 ) )

image
image1868×878 312 KB

Appreciate your help

Dan

2

Bumping this post for more visibility. Thanks!

1 Like
3

No replies on this, and I just can’t figure it out. All I want to do is run the secondary table logic as above, but filter just the result to show just aged stock and place it as a column in my Matrix table. id need to drop that into the values section of my table so it runs in conjunction with other Dax rows.

image