Matrix Visual on collapse show Blank

[Anonymous]

Hi all,

There is one requiremnt with Matrix visual.

I need to show blank at group level, it should not show average or sum instead it should show blank. When group is expanded it should show the corresponding values per subgroup level.

Currently when I minimize the "HR group", it shows the average of target and actual values.

I am using direct query mode. Is there any way that it should show Blank when minimized?

any pointers/help will be useful. Thanks in advance.

[Anonymous]

Thanks a lot @amitchandak, "isinscope" worked perfectly.

[amitchandak · Accepted solution]

@Anonymous , if you want not show data at some level in matrix, you can use isinscope

if(isinscope(Table[Col2]) && not(isincope(Table[Col3])), [Measure], blank())

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