Forum Discussion

CNC987654's avatar
CNC987654
Helper 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
    Super User
    7 years ago

    Hi,

    This measure should work

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

    Hope this helps.

  • MariaP's avatar
    MariaP
    Solution 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.