filter matrix visual on multiple column condition

[mhsieh]

Hi everyone,

I need help doing some visual filter on matrix across multiple columns. (please see below screenshot)

If [Sum Clicks] and [Prev Month Sum Clicks] are both 0 at the same time (MUST be both 0 at the same time), I don't want it to show in the matrix. How do I do that? 

Both columns are measures. Including the Dax Calculation here if that helps:

Sum Clicks = 
IF(
    ISBLANK(
        SUM('GSC query analysis'[Clicks])
    ),
    0,
    SUM('GSC query analysis'[Clicks])
)

Prev Month Sum Clicks =
CALCULATE(
    [Sum Clicks],
    DATEADD(
        'Calendar Lookup'[Start of Month],
         -1,
          MONTH
    )
)

Your help is much appreciated!! 

[PaulDBrown · Accepted solution]

Try:

Sum clicks not 0 =

IF(AND([Sum clicks] ==0, [Prev Month Sum Clicks] ==0), BLANK(), [Sum Clicks])

Prev Month Sum clicks not 0 =

IF(AND([Sum clicks] ==0, [Prev Month Sum Clicks] ==0), BLANK(), [Prev Month Sum Clicks])

[mhsieh]

This method works!! Thank you so much!