Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

filter matrix visual on multiple column condition

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!! 

  • 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])

2 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion

    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])

    • Anonymous's avatar
      Anonymous
      Not applicable

      This method works!! Thank you so much!