cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
xiaohongt
Microsoft
Microsoft

How to detect a value if it is in Subtotals column in Matrix?

Hi,

I need to detect a value if it is in Subtotals column in Matrix, e.g. below screenshot, how can I detect the red cells are in Subtotals column using DAX?  thanks

xiaohongt_0-1639453463412.png

 

1 ACCEPTED SOLUTION

@amitchandak , thank you so much! it works

View solution in original post

3 REPLIES 3
xiaohongt
Microsoft
Microsoft

@amitchandak , thank you for your help

amitchandak
Super User
Super User

@xiaohongt ,isincope can help

 

in this case

not(isinscope(Table[Date])  && isinscope(Table[Country])

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

@amitchandak , thank you so much! it works

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors