Forum Discussion
Matrix Visual on collapse show Blank
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 , 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/
2 Replies
- amitchandak
Super User
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/
Thanks a lot amitchandak, "isinscope" worked perfectly.