topic Re: Create Measure for Attendance (100% or 0%) in DAX Commands and Tips

Create Measure for Attendance (100% or 0%)

Anonymous — Sat, 08 Oct 2022 23:39:10 GMT

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%

Re: Create Measure for Attendance (100% or 0%)

Shaurya — Sat, 08 Oct 2022 23:55:45 GMT

Hi Anonymous,

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!

Re: Create Measure for Attendance (100% or 0%)

Anonymous — Sun, 09 Oct 2022 00:11:54 GMT

Thanks but I get this error:

Re: Create Measure for Attendance (100% or 0%)

Shaurya — Sun, 09 Oct 2022 00:27:10 GMT

Hi Anonymous,

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!

Re: Create Measure for Attendance (100% or 0%)

Anonymous — Sun, 09 Oct 2022 00:43:41 GMT

Perfect! Thanks so much for that!