Only Show Values in Matrix at Certain Levels

DAX DAX Calculations
1

Hi Everyone,

Looking for someone to get me started in the right direction here. I’ve included a screenshot of an existing matrix I have, for your reference. Unfortunately, I can’t include the PBIX file due to HIPAA and other confidential information.

This existing matrix has 4 levels:
–>State
–>Warehouse
–>Client Corporate Name
–>Client Branch Name

I only want the measures in red (COGS, COGS PPD, and GM%) to show values at the State and Warehouse levels. I would like for those values to be blank at the Client Corporate Name and Client Branch Name levels.

I’ve read that using “ISINSCOPE” might get me there, but I’m not familiar with that function, so wanted to ask this group before spending a lot of time learning that. Thanks in advance for any direction here!

Screenshot 2021-11-15 143429
Screenshot 2021-11-15 143429964×222 119 KB

2

Hi @daniel.new ,

Thanks for posting your question. ISINSCOPE is quite a straight forward function and it check if the column is in current filter context. You can use formula like below:

Sales Amount =
    IF (
        ISINSCOPE ( 'Date'[Month] ) || ISINSCOPE ( 'Date'[Date] ),  
        BLANK (),
        [Total Sales]
    )

In above measure, if context is in Month/Date, then it will show blank otherwise it will show values. Replace columns/measures in above measure and you should get your response.

Regards,
Hafiz

1 Like
3

Thank you for the help. I got it work! Much appreciated!

1 Like