topic Re: Add Total to Matrix in Developer

Add Total to Matrix

thedocs — Thu, 06 Apr 2023 15:06:34 GMT

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.

Re: Add Total to Matrix

lbendlin — Mon, 10 Apr 2023 00:44:40 GMT

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.

Re: Add Total to Matrix

thedocs — Thu, 13 Apr 2023 14:44:47 GMT

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.

Re: Add Total to Matrix

lbendlin — Thu, 13 Apr 2023 20:05:33 GMT

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

Re: Add Total to Matrix

thedocs — Mon, 17 Apr 2023 11:50:42 GMT

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

Re: Add Total to Matrix

lbendlin — Mon, 17 Apr 2023 22:01:57 GMT

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.

Re: Add Total to Matrix

thedocs — Tue, 18 Apr 2023 07:38:13 GMT

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