Show Dimension of Min and Max value

billuran — Fri, 02 Apr 2021 08:00:28 GMT

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

Re: Show Dimension of Min and Max value

Lisa_P — Mon, 08 Jul 2019 23:01:51 GMT

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

topic Show Dimension of Min and Max value in App Development

Show Dimension of Min and Max value

Re: Show Dimension of Min and Max value