Forum Discussion
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
- PaulDBrownCommunity 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])
- AnonymousNot applicable
This method works!! Thank you so much!