Grand Total on Matrix

[CNC987654]

By default, PowerBI automatically sums all numeric fields in the grand totals. But some fields dont make sense. For example, the age field below. Is there a way to turn off (remove) grand total for selected fields?

[MariaP · Accepted solution]

Hi @CNC987654 ,

Within Power BI , select 'Field Formatting' - > Age - > then Make the Font Color White and apply only to the Totals.

This masks the total for Age.

[Ashish_Mathur]

Hi,

This measure should work

=IF(HASONEVALUE(Data[Name]),SUM(Data[Age]),BLANK())

Hope this helps.

[CNC987654]

Do you have a screen shot of where to apply the measure? thanks

[Ashish_Mathur]

Hi,

Go to Modelling > New Measure.