Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help Calculate with 2 conditions

I want to calculate with 2 conditions:

 

Example: calculate if person attended = Yes, and person provided feedback = Yes

 

calculate(totalattendees), attendees[attended] = 'Yes' & attendees[feedback] = 'Yes'

 

unsure how to setup this calculation, new to these calculations 🙂 thanks for the help in advance!

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    calculate([totalattendees], FILTER('attendees', attendees[attended] = "Yes" && attendees[feedback] = "Yes"))

    If [totalattendees] is a measure, otherwise, perhaps.

    COUNTROWS(FILTER('attendees', attendees[attended] = "Yes" && attendees[feedback] = "Yes"))

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago
    calculate([totalattendees], FILTER('attendees', attendees[attended] = "Yes" && attendees[feedback] = "Yes"))

    If [totalattendees] is a measure, otherwise, perhaps.

    COUNTROWS(FILTER('attendees', attendees[attended] = "Yes" && attendees[feedback] = "Yes"))