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 colu...
  • 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" }
)

     

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