Create Measure for Attendance (100% or 0%)

[mccardj]

Hi,

I've created a table by appending "Required Attendee" with "Attendance" with the goal of visualising this to see an Attendance report. As you can see, for this particular "Meeting ID" 4 people were invited, but only 2 people attended (Name ID = 1112 and Name ID = 1703).

How can I write a measure to show the full list of attendees with a column showing those who attended as 100% and those who didn't as 0%?

Something like this:

Name ID	Attendance
67	0%
139	0%
1112	100%
1703	100%

[mccardj]

Perfect! Thanks so much for that!

[mccardj]

Thanks but I get this error:

[Shaurya]

Hi @mccardj,

Since this will return a table, you can not create this formula as a measure. Use it to create a new DAX table.

Did I answer your question? Mark this post as a solution if I did! 

[Shaurya · Accepted solution]

Hi @mccardj,

You can use the following DAX Formula to create the result table:

Attendance Percentage = SUMMARIZE('Table','Table'[Name ID],"Attendance",IF(MIN('Table'[Type])="Attendance",1,0))

Format the Attendance column as percentage to see this result:

Works for you? Mark this post as a solution if it does!