Count number of attendees based on non blank attendee name fields

[gingerclaire]

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?

[djurecicK2]

First I would consider unpivoting that table:

https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882...

[djurecicK2]

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!

[gingerclaire]

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