Forum Discussion

e175429's avatar
e175429
Icon for Helper IV rankHelper IV
1 year ago
Solved

Calculate w/Multiple Filters on Multiple Columns

 

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's avatar
    DataInsights
    1 year ago

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

     

1 Reply

  • DataInsights's avatar
    DataInsights
    Icon for Super User rankSuper User
    1 year ago

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