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...
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.