How to filter out rows with zero row totals in a Power BI table visual?

[manish-tripathi]

My Power BI table visual is cluttered with rows where all the values add up to zero. I only want to see rows with meaningful data. How can I filter or calculate to display only rows with non-zero totals?

Wanted to add the row field and values in the table can be dynamically changed using field paramenters, so the filter on the visual keeps on changing based on the selected combination of row field and value field

[Chakravarthy · Accepted solution]

Hi @manish-tripathi  - Please create a measure similar as below

Measure1 = CALCUALTE(SUM(Table[Sales])

Bring this Measure1 on the visual Filter and select is not 0