Add Total to Matrix

Question

Hi all,I have below page and cant get the 2 totals added on the Matrix as shown below. You can see also where they have been added highlighted in Yellow on the Row. I have spent hours playing with settings but cant get it. Any help very much appreciated.&nbsp;&nbsp;

lbendlin · Answer

Examine yourt measures.&nbsp; Things like SELECTEDVALUE have no meaning in the totals row and will result in BLANK(). Rewrite the measures using SUMMARIZE/SUMMARIZECOLUMNS and SUMX.

thedocs · Answer

thank you for your response. I am pulling the 2 columns I need the totals from directly from a table as was created inside Power Query so is not a measure or even Dax.

lbendlin · Answer

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

thedocs · Answer

I have uploaded the report to below location, I need to add a total to the column 'FY 2022' which I have not been able to do. I have been able to add total to the column 2023. Note the 'FY 2022' needs to stay in the row column.

Lintels Sales Laptop Report Test Total.pbix

lbendlin · Answer

Thank you for the sample data. Are you expecting the FY23 table to expand dynamically with each month?&nbsp; If yes then you will be mucn better off using two separate tables, one for each FY.

Forum Discussion

Add Total to Matrix

6 Replies

Related content

Totals in Matrix

Matrix Totals Incorrect

Add a grand total to a matrix or table

Formatting grand total in matrix

Matrix Row Totals