Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello PBI folks,
How do i make the Avg Daily Rate Grand Total (red box) similar to the one in Tableau (green box) where it shows the Grand Avg for the Avg Daily Rate?
Expected output:
Thanks!
Solved! Go to Solution.
Hi @cruzp The measure is :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi! The AVERAGEX function should get you where you want to be AVERAGEX function (DAX) - DAX | Microsoft Learn
Proud to be a Super User! | |
Can't seem to make it work. Any chance you can assist on the calculation?
If you could upload a pbix file, I can take a look
Proud to be a Super User! | |
Hi @cruzp
Totals problems are a known issue.
Please refer to the linked tutorials about workarounds to fix this problem :
https://www.youtube.com/watch?v=dgwsk2fjWLc
https://www.youtube.com/watch?v=yw0QHu9V4UQ&t=617s
https://www.youtube.com/watch?v=wHAWZzVS48Q
Also, there is an idea of @Greg_Deckler about the issue, please vote for it :
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Can't seem to make it work as I tried following the youtube tutorials. Any chance you can assist on the calculation?
Hi @cruzp
Try to use averagex as @audreygerred suggested.
To assist more I need data to work
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
hi here is the .pbix in the dropbox
Hi @cruzp The measure is :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
I saw that the BILLING CURRENCY is included in the formula. What if i wanted to add a new descriptive field next to it?
does it mean that any fields that I would add in the granularity of the table should be added in the calculation? @Ritaf1983
Hi @cruzp
Yep, with this formula you are creating a "virtual table" and then summarizing it (similar to the pivot logic of Excel).
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
61 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |