Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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,
Solved! Go to Solution.
hi @luisman67
I am assumin that your Datamodel has active relationships between these three tables.
For Capacity use this measure.
Thanks a lot Tailspin!!, worked perfect!
Best regards!!
hi @luisman67
I am assumin that your Datamodel has active relationships between these three tables.
For Capacity use this measure.
User | Count |
---|---|
66 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
120 | |
41 | |
40 | |
28 | |
23 |