Power BI

Hello everyone,

I have a dashboard which contain table matrix and contain hierarchy.

I have 3 measure (actual, plan and variance). User want to filter rows from table matrix which has 0 in all columns.

I created a new measure (zero-flag= actual + Plan) so if both plan and actual would have zero then zero-flag would contain 0 else some value.

I used this flag in my power bi report "page filter" section.

after adding zero-flag in page filter section report is taking ages to load while earlier it was loading in 5-25 seconds only.

Is there any way to filter zero values rose from table matrix?

Thanks in advance.

Prashant