Forum Discussion

Anonymous

Not applicable

7 years ago

Hide rows in matrix

I have Matrix table with 3 measures Abc 120 NNN 0 Xyz 50 i need to reomve row NNN with 0 value Please advice me to sort this Thanks

Super User

7 years ago

Hi,

Write this measure. Measure1 is the measure that returns 120,0 and 50:

=IF(ISBLANK([Measure1]),BLANK(),[Measure1])

Hope this helps.