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[feedb...
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"))
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"))