Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @Salman_85,
Currently it is not supported to show max/min/median row like the total row under details data.
As a workaround, you can plot max/min/median values in column level.
Alternatively, to show max/min/median values in row level, you need a calendar table with a different table structure.
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 table1 = UNION ( SUMMARIZE ( SELECTCOLUMNS ( 'summary table', "Executive", "Total", "Revenue", 'summary table'[Total for Revenue], "Bookings MRR", 'summary table'[Total for MRR] ), [Executive], "Revenue", AVERAGE ( 'summary table'[Total for Revenue] ), "bookings MRR", AVERAGE ( 'summary table'[Total for MRR] ) ), SUMMARIZE ( SELECTCOLUMNS ( 'summary table', "Executive", "Max", "Revenue", 'summary table'[Max for Revenue], "Bookings MRR", 'summary table'[Max for MRR] ), [Executive], "Revenue", AVERAGE ( 'summary table'[Max for Revenue] ), "bookings MRR", AVERAGE ( 'summary table'[Max for MRR] ) ) )
New Table2 = UNION ( SELECTCOLUMNS ( 'summary table', "Executive", 'summary table'[Executive], "Revenue", 'summary table'[Revenue], "Bookings MRR", 'summary table'[Bookings MRR] ), 'New table1' )
Use a table visual to display data from 'New Table2'.
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |