Add Total to Matrix

[thedocs]

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.

[thedocs]

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]

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

[thedocs]

Hi Ibendlin, I appreciate the help, no I just need a total added for 'FY 2022',

[thedocs]

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]

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-...
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

[lbendlin]

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