Calculating Attendance at Events

luisadavidson — Thu, 04 Jun 2020 11:07:38 GMT

Hi there,

Hope you can help as I'm fairly new to DAX.

I have a column in my data called 'booking status' with either 'Attended', 'Absent', or 'Booked'. I have a matrix table that shows this, along with the total number of events. I need to calculate the sign up vs. turn up to the events - so out of everyone that booked, how many people attended the events but I'm struggling to work out whether I need a measure or a column or both.

Here is an example of the data:

What's the best/easiest way to do this as a % column?

Many thanks!

Luisa

Re: Calculating Attendance at Events

Anonymous — Thu, 04 Jun 2020 11:42:08 GMT

Hi luisadavidson ,

You can create a measure.

var AttendedEvent = SUM('Table'[Attended])
var BookedEvent = SUM('Table'[Booked])

Return

DIVIDE(BookedEvent,AttendedEvent)

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

topic Re: Calculating Attendance at Events in DAX Commands and Tips

Calculating Attendance at Events

Re: Calculating Attendance at Events