Show Dimension of Min and Max value

[billuran]

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

[Lisa_P · Accepted solution]

Just remove the '-' sign. This means descending, no symbol is ascending.