How to hide row with zero in the total column of visual matrix

[Anonymous]

Hello,

I created a visual matrix in Power BI. Few of the rows have zero as data. I would like to know a way to hide these. The matrix is as below:

Department	USA	Canada	UK	France	Total
Accounting	1	0	1	1	3
Finance	0	0	0	0	0
Dev	1	0	1	1	3
Manufacturing	1	0	1	1	3
Total	3	0	3	3	9

This is just a sample there are multiple columns and rows that add to zero. Is there a way to filter the zero out from the totals column that is automatically calculated when I make the matrix viz.?

Thanks

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

You could create a measure

Measure =
VAR total_ =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            'Table',
            'Table'[Value] <> 0
        )
    )
RETURN
    IF (
        ISINSCOPE ( 'Table'[Country] ),
        IF (
            ISINSCOPE ( 'Table'[Department] ),
            SUM ( 'Table'[Value] ),
            total_
        ),
        total_
    )

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

You should be able to create a measure that emulates the Total calculation and then filter on that.

[Anonymous]

Thanks for the reply. I tried the below filter. EBITDA is the measure but it did not work.