Forum Discussion

CNC987654's avatar
CNC987654
Icon for Helper I rankHelper I
7 years ago
Solved

Grand Total on Matrix

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 s...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • MariaP's avatar
    MariaP
    7 years ago

    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's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

This measure should work

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

Hope this helps.

CNC987654's avatar
CNC987654
Icon for Helper I rankHelper I
7 years ago

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

    Go to Modelling > New Measure.