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, ...
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)

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)