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 selected fields?

 

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.

     

     

     

4 Replies

  • 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

  • MariaP's avatar
    MariaP
    Icon for Solution Supplier rankSolution Supplier
    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.