Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a basic question. I would like to create a measure for a filtered value of a column, providing/displaying the total number of attendees for a particular ‘interaction type’.
Table Name = Consolidated
Column Name = Interaction Type
Column Name = Total Number of Attendees
Examples of interaction types Face to Face, Virtual
I want to create a DAX expression to display/count of Total Number of Attendees, for the Interaction Type of Virtual.
I cannot use a quick measure as I need to be able to use this elsewhere and quick measure does not allow the filtering I need.
Thank you.
Solved! Go to Solution.
measure name = CALCULATE(SUM('Consolidated'[Total Number of Attendees]), FILTER('Consolidated', 'Consolidated'[Interaction Type] = "Virtual"))
Something like the above should work.
Measure = CALCULATE(COUNT(Consolidated[Total Number of Attendees], Consolidated[Interaction Type] = "Virtual")
measure name = CALCULATE(SUM('Consolidated'[Total Number of Attendees]), FILTER('Consolidated', 'Consolidated'[Interaction Type] = "Virtual"))
Something like the above should work.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 133 | |
| 88 | |
| 85 | |
| 68 | |
| 64 |