Calculating Attendance at Events

[luisadavidson]

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

[harshnathani · Accepted solution]

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)