Forum Discussion
Solved
Hide last level values from matrix table
Hi everyone, I have a matrix table that l need to hide the value of last level. Note: Im using measures. Someone can help me with this? This is how my data looks like: Continent Country Sta...
Hey salucas,
You can easily process this in a measure using the ISINSCOPE function. As long as the 'State' column is not in scope you will show the 'Total', otherwise not:
Measure = IF ( NOT ISINSCOPE ( 'Table'[State] ), SUM ( 'Table'[Total] ) )For 'State' make sure you show items with no data.
Result:
