Forum Discussion

BBlue20025's avatar
BBlue20025
Frequent Visitor
3 months ago
Solved

Matrix - Can Primary Row Be It's Own Calculation From Sub-Rows?

Hello. I am new to PowerBI, so I apologize if this is not explained correctly.   I have a matrix where there are Primary Rows each with Sub Rows similar to a Region and all the Stores that exist in...
Need Help
  • v-veshwara-msft's avatar
    v-veshwara-msft
    3 months ago

    Hi BBlue20025 

     

    The Customize totals option works when the visual contains aggregated fields, measures, or visual calculations.

     

    To access it, you can:

    ->Right click on the column that contains the Total value and select New visual calculation -> Custom
    -> Or right click directly on the total cell value in the column to configure Customize totals from there.

     

    You can also access the same option from the Build section by clicking the dropdown next to the measure or aggregation used in the table visual.

     

    This feature was introduced starting from the March Desktop release. So if you are using an older version of Power BI Desktop, please update to the latest version to access this functionality.

     

    For Reference;

    Power BI March 2026 Feature Summary - Microsoft Fabric Community

    Create and Format Table Visualizations in Power BI - Power BI | Microsoft Learn

     

    Hope this helps. Please reach out for further assistance.
    Thank you.

danextian's avatar
danextian
Super User
3 months ago

Hi BBlue20025 

You can show a different aggregation for the subtotals directly from the customize total options.

Or create a measure that iterates over a table or table expression

 

 

  • BBlue20025's avatar
    BBlue20025
    Frequent Visitor
    3 months ago

    Hi danextian,

     

    How come I do not have that Customize option?

     

     

     

    • v-veshwara-msft's avatar
      v-veshwara-msft
      Community Support
      3 months ago

      Hi BBlue20025 

       

      The Customize totals option works when the visual contains aggregated fields, measures, or visual calculations.

       

      To access it, you can:

      ->Right click on the column that contains the Total value and select New visual calculation -> Custom
      -> Or right click directly on the total cell value in the column to configure Customize totals from there.

       

      You can also access the same option from the Build section by clicking the dropdown next to the measure or aggregation used in the table visual.

       

      This feature was introduced starting from the March Desktop release. So if you are using an older version of Power BI Desktop, please update to the latest version to access this functionality.

       

      For Reference;

      Power BI March 2026 Feature Summary - Microsoft Fabric Community

      Create and Format Table Visualizations in Power BI - Power BI | Microsoft Learn

       

      Hope this helps. Please reach out for further assistance.
      Thank you.

      • v-veshwara-msft's avatar
        v-veshwara-msft
        Community Support
        3 months ago

        Hi BBlue20025 ,

        Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
        Thank you.