Forum Discussion

mauroanelli's avatar
mauroanelli
Icon for Helper I rankHelper I
8 years ago

hide row with zero value in visual matrix with two or more field

hi all, i know that to hide row in matrix visual with zero value you just can put the value field in page filter and filter it different from zero, and it works fine when you have just one field in ...
Need Help
mauroanelli's avatar
mauroanelli
Icon for Helper I rankHelper I
8 years ago

 i've come to this:

i create a measure that is the sum of the two field

Filter Residuo Dare/Avere = SUM(ICS_BI_Reports[Residuo Dare])+SUM(ICS_BI_Reports[Residuo Avere]) 

i've put that measure in visual filter set to show elements when value is not 0

and it's work but if someone have some simplest idea i'd like to hear it

regards