Forum Discussion

luisadavidson's avatar
luisadavidson
Frequent Visitor
6 years ago
Solved

Calculating Attendance at Events

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

columns
DAX
Measures
  • Anonymous's avatar
    Anonymous
    6 years ago

    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)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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)