Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have an expression that shows the max value based on the dimension room:
max(aggr(sum(aggr(sum(DISTINCT Patients),CaseID))/((((max(total [Start Date])-min( total [Start Date]))/7*(count(distinct [Day of Week]))+1))*Hours*count(DISTINCT Room)),Room))
How can i show the actual dimension with the max value in a text box.
IE: Max Value: 81% Room B
Update I uses Firstsortedvalue for max, but not sure how to do min.
=
FirstSortedValue(Room,-
(aggr(
sum(aggr(sum(DISTINCT Patients),CaseID))/
((((max(total [Start Date])-min( total [Start Date]))/7*(count(distinct [Day of Week]))+1))*Hours*count(DISTINCT Room)),Room)))
Just remove the '-' sign. This means descending, no symbol is ascending.
Just remove the '-' sign. This means descending, no symbol is ascending.