Skip to main content

Power BI

New

Matrix/Table grand totals with Measures

Vote (10) Share
's profile image

on 16 Jul 2018 15:59:57

It would be great if Grand Totals on a Matrix or Table would add up correctly to the sum of the rows when you include MEASURES in the visual. Currently the total on a measure consists of the measure function itself, instead of the sum of the rows above. PLEASE give us the option to toggle totals to be a simple aggregate of the rows above also.

Comments (1)
's profile image Profile Picture

3a62b55e 06f9-43e1-a9c6-2cae83c69a7e on 05 Jul 2020 23:54:22

RE: Matrix/Table grand totals with Measures

Total Mode

1. No Total
2. Expression Total
3. Sum of rows

Maybe the third option can be a dropdown where we can choose Sum/Avg/Min/Max etc