cancel
Showing results for
Did you mean:
Frequent Visitor

## Create Measure for Attendance (100% or 0%)

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%

1 ACCEPTED SOLUTION
Memorable Member

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!

4 REPLIES 4
Frequent Visitor

Perfect! Thanks so much for that!

Frequent Visitor

Thanks but I get this error:

Memorable Member

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!

Memorable Member

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!

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors