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.