Row total of absolute values in the matrix visual

[Anonymous]

Hi,

I have a table that looks like this:

Id	January	February	March	April	May	Total	Abs Total (desired)
AAA	10	20	30	15	25	100	100
BBB	-10	0	10	0	0	0	20
CCC	0	0	0	0	0	0	0

I want to remove the third row (all zeros), but keep the second one, which has a non-zero absolute total.

I created a measure with absolute numbers, like 

Abs Rows = sumx(summarize('table', 'Ids'[Id]), abs(values))

However, the calculated total of the matrix just converts 0 from the regular total to 0 (I guess, similar to column totals).

How can I get the true total for absolute values here? I believe then, I could use an if statement to filter out the all-zero rows from the matrix. 

[dax · Accepted solution]

Hi @Anonymous , 

You could refer to my sample for details. If you want to remove o in third, you could apply filter in measure.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.