Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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):
Solved! Go to 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.
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
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
81 | |
70 | |
49 |
User | Count |
---|---|
143 | |
124 | |
107 | |
60 | |
55 |