Calculate w/Multiple Filters on Multiple Columns

[e175429]

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!

[DataInsights · Accepted solution]

@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" }
)