Hella all,
i have two measures in my framework:
A- number of patients (count distinct patient)
B- total hours spent on a hospital bed
now i'd like to add a third measure with the following calculation : B/A (average hours spent on a bed p.patient)
How can i do this avoiding the problem that using this measure in query studio it does not add up the averages but keep using the calculation on each aggregation level i use on the grid?
averages are by nature not additive. Why are you looking for a way to add them up?
Setting aggregation property to 'Calculated' will reapply the data item calculation at the aggregate level.