Max, Median and Min

Question

&nbsp;Hi,This is summary table view from report. I need Max median and Min underneath total or may 3 different measure or any other solution and how to calculate these values. Please guide. Thanks.&nbsp;&nbsp;&nbsp;

v-yulgu-msft · Answer

Hi&nbsp;Salman_85,
&nbsp;
Currently it is not supported to show max/min/median&nbsp;row like the total row under details data. 
&nbsp;
As a workaround, you can plot max/min/median values in column level.

&nbsp;
Alternatively, to show max/min/median values in row level, you need a calendar table with a different&nbsp;table structure.&nbsp;
&nbsp;
In original table, create calculated column to generate total/max/min for each category.
Total for Revenue = SUM('summary table'[Revenue])
Max for Revenue = MAX('summary table'[Revenue])

Create calculated tables using below formulas:
New&nbsp;table1&nbsp;=
UNION&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;SUMMARIZE&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECTCOLUMNS&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'summary&nbsp;table',
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Executive",&nbsp;"Total",
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Revenue",&nbsp;'summary&nbsp;table'[Total&nbsp;for&nbsp;Revenue],
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Bookings&nbsp;MRR",&nbsp;'summary&nbsp;table'[Total&nbsp;for&nbsp;MRR]
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Executive],
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Revenue",&nbsp;AVERAGE&nbsp;(&nbsp;'summary&nbsp;table'[Total&nbsp;for&nbsp;Revenue]&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"bookings&nbsp;MRR",&nbsp;AVERAGE&nbsp;(&nbsp;'summary&nbsp;table'[Total&nbsp;for&nbsp;MRR]&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;SUMMARIZE&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECTCOLUMNS&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'summary&nbsp;table',
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Executive",&nbsp;"Max",
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Revenue",&nbsp;'summary&nbsp;table'[Max&nbsp;for&nbsp;Revenue],
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Bookings&nbsp;MRR",&nbsp;'summary&nbsp;table'[Max&nbsp;for&nbsp;MRR]
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Executive],
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Revenue",&nbsp;AVERAGE&nbsp;(&nbsp;'summary&nbsp;table'[Max&nbsp;for&nbsp;Revenue]&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"bookings&nbsp;MRR",&nbsp;AVERAGE&nbsp;(&nbsp;'summary&nbsp;table'[Max&nbsp;for&nbsp;MRR]&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;)
)

&nbsp;
New&nbsp;Table2&nbsp;=
UNION&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;SELECTCOLUMNS&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'summary&nbsp;table',
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Executive",&nbsp;'summary&nbsp;table'[Executive],
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Revenue",&nbsp;'summary&nbsp;table'[Revenue],
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Bookings&nbsp;MRR",&nbsp;'summary&nbsp;table'[Bookings&nbsp;MRR]
&nbsp;&nbsp;&nbsp;&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;'New&nbsp;table1'
)

&nbsp;
Use a table visual to display data from 'New Table2'.

&nbsp;
Best regards,Yuliana Gu

Forum Discussion

Max, Median and Min

1 Reply

Related content

Help with Median

Min/Median/Max Matrix

table showing min, median, and max

Median times

Max Count