topic Re: Not show total in grouped Matrix Column in DAX Commands and Tips

Not show total in grouped Matrix Column

OCBB_SFAFPandA — Fri, 27 May 2022 04:25:28 GMT

Hello,

I am trying not to show the anything for the grouped matrix total since it doesn't make sense. when I drill down, the info i want is there. Just need to remove the ones from the grouped total. There's a lot of data under there, so I want to keep grouped.

Re: Not show total in grouped Matrix Column

amitchandak — Sat, 28 May 2022 00:30:19 GMT

OCBB_SFAFPandA , Use isinscope

Switch(true(),

isinscope(table[Store]) ,[Measure] , //Lower level

isinscope(table[group], blank())

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

Re: Not show total in grouped Matrix Column

v-easonf-msft — Tue, 07 Jun 2022 07:11:23 GMT

Hi, OCBB_SFAFPandA

Please check if this tutotial could help.

Use IsInScope to get the right hierarchy level in DAX

Best Regards,
Community Support Team _ Eason