Forum Discussion
How to hide value in Matrix when not expanded/collapsed?
how not to show value in matrix column? If not expanded i want it to be blank, then when i collapsed i will see the value. thanks in advance
Hi, Anonymous
you can try to match the text color to the background so that it looks blank, that could be a woraround. or you can use ISINSCOPE dax func to determine your your current level of drill down.for example,
Measure = IF( ISINSCOPE(Table[YourColumnName]), SUM(Table[YourValueColumn]), BLANK() )refer: https://learn.microsoft.com/en-us/dax/isinscope-function-dax
got it thank you
if my answer is helpful then accept it as a solution and why not give it a kudos.