cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## 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],
'Calendar Lookup'[Start of Month],
-1,
MONTH
)
)``````

1 ACCEPTED SOLUTION
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])

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

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

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

Helper II

This method works!! Thank you so much!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors