Changing Matrix Totals and Subtotals

[hacksverstappen]

Hi,

I'm currently working through a problem where I have created a matrix in my dashboard that sums each resources utilization percent across each project they're working on. However, the subtotals and grand totals sum up the percentages, but I need both of these totals to show the Average of the Summed up resource utilization. I've seen solutions where the inverse occurs but I can't seem to reverse the code to solve my problem. Can someone let me know how to do that? For reference, my values are sum of sep, sum of oct, etc. because there are multiple projects that need to be summed up per resource.

here is what I currently have:

this the goal (only calculated on 2 columns because that's a lot of math):

[rohit_kathuria]

Hi There, Impressed with the stuff you are doing, looks like i am also trying to achieve the same, I am looking to build a dashboard for my team utilisation, Planned vs actual , for now it could be import from 2 excels however in th elonger run, i want to integrate this from SAP time sheet module and get the data, Can you please share the pbix files at  burlington20062006@gamil.com, Appreciate in advance

[v-yalanwu-msft · Accepted solution]

Hi, @hacksverstappen ;

Try to create a measure. i create a simple data .

AVERAGEX(SUMMARIZE('financials',[Product],[Country],"1",SUM([percent])),[1])

the final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.