Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table for an appointment and it has columns as follows for each event (each row):
Attendee 1 name
Attendee 2 name
Attendee 3 name
Attendee 4 name
Attendee 5 name
Attendee 6 name
(all the way to 16!)
I need a measure to count the number of attendees at each appointment - by counting the non blanks in the name field.
I am completely stuck on how to do this - please can you help?
First I would consider unpivoting that table:
Hi @gingerclaire ,
You should be able to use the COUNTA function to do this.
(Adapt for your table and field names)
Number of Attendees= COUNTA(Table[FieldName])
https://learn.microsoft.com/en-us/dax/counta-function-dax
Counts the number of rows in the specified column that contain non-blank values.
Please consider accepting as solution if this answers the question- thanks!
Thank you - I need to be able to do this across multiple fields for the table as below (I actually have 16 attendee fields):
Attendee1name | Attendee2name | Attendee3name | Attendee4name | Attendee5name | Attendee6name | Total attendees | |
Event 1 | John | Sarah | James | Geoff | 4 | ||
Event 2 | Helen | Bob | 2 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |