Need help on total of a measure

[luisman67]

Hello, we are trying to calculate assitance to fitness activities, i have managed to calculate assitance rate for each activity interval, but i cannot get the average total. We have 3 connected tables:

Activities: where i can get capacity of each

Intervals: each activity, i.e. Ioga, develops in different intervals i.e. mondays at 6pm, tuesdays at 10 am, and so on..

Reservations: made by users to each interval

When i use a table to summarize data appears as below. Capacity is only summarize if i use max.Capacity, but OccupacyRate is not well summarized

Thank you very much for your help,

Regards,

[luisman67]

Thanks a lot Tailspin!!, worked perfect!

Best regards!!

[talespin]

hi @luisman67 

You're welcome.

[talespin · Accepted solution]

hi @luisman67 

I am assumin that your Datamodel has active relationships between these three tables.

For Capacity use this measure.

Capacity = SUMX( SUMMARIZE(Reservations, Reservations[IntervalID], Activities[Capacity]), [Capacity])

OccupationRate = DIVIDE( COUNT(Reservations[PersonID]), [Capacity])