topic Calculate w/Multiple Filters on Multiple Columns in DAX Commands and Tips

Calculate w/Multiple Filters on Multiple Columns

e175429 — Tue, 07 Jan 2025 21:51:58 GMT

Hello all,

I am trying to write a query that basically says:

calculate the total number of extremely satisfied + very satisfied,
where year = 2024,
and quarter = Q1

here are the 3 columns:

So far I have a total response measure for 2024:

a total of how many people voted extremely and very satisfied in 2024:

I'm not quite sure how to put it all together.

Thank you!

Re: Calculate w/Multiple Filters on Multiple Columns

DataInsights — Tue, 07 Jan 2025 22:26:12 GMT

e175429,

Try this measure. The filter arguments are combined (intersected).

total extremely/very 2024 Q1 = CALCULATE ( [total], pivotedQuestions[Year] = 2024, pivotedQuestions[Quarter] = "Q1", pivotedQuestions[Overall, how satisfied were you with your live chat experience?] IN { "Very satisfied", "Extremely satisfied" } )