Solved: Help Calculate with 2 conditions

Anonymous · ‎04-17-2020

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!

Greg_Deckler · ‎04-17-2020

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Greg_Deckler · ‎04-17-2020

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...