Forum Discussion
Matrix - Can Primary Row Be It's Own Calculation From Sub-Rows?
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.
I'm not too familiar with how to use dax yet.
In the original data, I have columns by Store and Month.
I created a column that was the average for the 3 oldest columns:
= Table.AddColumn(#"Reordered Columns", "JFM_AVG", each List.Average(List.RemoveNulls({[January], [February], [March]})))
Followed by a column to get the % comparison of the newest month compared to the AVG of the previous three months
= Table.AddColumn(#"Added Custom", "PERC", each (([April]/[JFM_AVG)-1))
And then a column to look up the Region based on the Store
= LOOKUPVALUE('Region'[Region],'Region'[Store],'Store'[Store])
How would I use the dax example? Where do I type it?
Hi,
Please share the download link of the PBI file.
Unfortunately I cannot share the true data.
You can share anonymised data.
I'm not sure how to modify it for that.
Does this image help explain? I currently get -17% in my Primary Row as the average of the Secondary Rows, but I want it to calculate as shown for -15%.