How to filter 0 from the table and not affect measures

[Donia12215]

Hi

I have table with 3 measures. How can I hide Quorter var equal to 0? When I used filters on this visual and set Quorter var is not 0 at the same time % cap and PQ % cap were affected. Is there any workaround?

[tamerj1]

Hi @Donia12215 

Please try

Quorter var =
VAR TimePercent = [time % cap]
VAR PQPercent = [PQ % cap]
RETURN
    IF ( TimePercent + PQPercent > 0, TimePercent - PQPercent )