cancel
Showing results for
Did you mean:
Post Patron

## Subtotal/Grand Total Not Accurate

Hi,

I have created a formula:

Onst - Cmpl = format(average('CMPL Table'[ONST to CMPL-EMST]),"HH:MM")
to display the average time it takes for a job to be completed. I am trying to figure out a way to display the average in the rows, but the sum of the averages in the subtotal and total based on the groups on the left.

I tried doing the sum of the formula, but it does not display the correct totals either.

Is there another formula I can use, or am I using this formula wrong?

please let me know if my question does not make sense.

Thank you!
1 ACCEPTED SOLUTION
Super User

@sk15227 This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
Check out my latest book!

2 REPLIES 2
Super User

@sk15227 This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
Check out my latest book!

Post Patron

Thank you so much!! this was very helpful!

Announcements