Filter 0 from matrix

[Joe_100]

Hi all,

I think i have a simple question but cant find a way to do it in Powerbi.

Please see simplified table below.

If i filter 0 from the matrix, the top row dissapears as 1 and -1 = 0.

How can i keep this row and remove column E in this case.

I somehow need a DAX formula that respects the context of sum per column and row?

many thanks in advance!

[Anonymous · Accepted solution]

Hi @Joe_100 ,

I am afraid that there is no elegant way to implement it. Anyway, you can use the following method as a  workaround:

1.Create a simple table.

2.Select a Matrix visual. Move the Column2 to Rows, move the Column1 to Columns, and move the value to Values.

3.Create a Sum of Value Measure.

4.The matrix remove the column E.

5.If the above one can't help you, could you please provide more raw data(exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution.

Looking forward to your replay.

Best Regards,

Wisdom Wu