Matrix/Table grand totals with Measures

[p_lamonica]

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.

[nishalit]

Add, please, easy variant to sum measures in total rows, for example, in check-button: - sometimes we have to sum measures in total row (see reference), - sometimes we want to get result of measure calculation as it is http://community.powerbi.com/t5/Desktop/DAX-sum-measures/td-p/24364

[s_roa]

i guess It would be nice 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.

[fbcideas_migusr]

Thanks for this voting it's very important

[khanh_tran]

Please repair it as it's really BAD.

[fbcideas_migusr]

As a user coming from Tableau this is is so infuriating that I can’t simply toggle between totals being calculated on a visual level, or on using the underlying calc. Using sumx to correct this can get difficult with using virtual tables. - please make this easier for your users!

[fbcideas_migusr]

I think it could be a choice. Maybe we could have a parameter in the matrix settings to select the optimal behavior for total calculations in each situation.

[fbcideas_migusr]

Come on Microsoft, it's about time!!!

[Niloufar_Mohase]

Such a headache :'(

[dsapostolopoulo]

Not to mention that Qlik has this feature since QlikView...

[Sivarajan_C]

Thanks your for taking this initiative.

This saves lot of time for power bi developers.