topic Re: Need help on total of a measure in DAX Commands and Tips

Need help on total of a measure

luisman67 — Thu, 14 Mar 2024 13:18:18 GMT

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,

Re: Need help on total of a measure

talespin — Fri, 15 Mar 2024 04:53:24 GMT

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])

Re: Need help on total of a measure

luisman67 — Fri, 15 Mar 2024 06:31:26 GMT

Thanks a lot Tailspin!!, worked perfect!

Best regards!!

Re: Need help on total of a measure

talespin — Fri, 15 Mar 2024 06:45:25 GMT

hi luisman67

You're welcome.