cancel
Showing results for
Search instead for
Did you mean:
Frequent Visitor

## 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!

1 ACCEPTED SOLUTION
Super User
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"))

@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition
1 REPLY 1
Super User
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"))

@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

## Helpful resources

Announcements

#### The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

#### Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

#### Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors