Summing the Measures - I'm missing something

[Anonymous]

Hello Power BI Community,

I am a new user, self learning for the time being. I have training set up for Last March and April by my boss.  I have seen multiple posts regarding the total of the measure column isn't correct. I have that same issue.

My measure is: 

SC LW Margin $ = if('SC Measure Table'[SC LW Dollars]>0,'SC Measure Table'[SC LW Dollars]-('SC Measure Table'[SC LW Turn Rate]*'SC Measure Table'[SC LW Available Inv $])/52,0)

And at the total, it shows -$242,XXX,XXX and I have multiple columns that I will have to fix besides this. If the turn rate was not "324.18" and around 4.X, the margin total would be right. I am not sure how to fix the turn rate total, or else the measure total using the links experts provided: these were just a few that I looked at.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Your help / guidance are appreciated. Have a great weekend. Please let me know if I can provide any more info to find the solution.

MT

[v-lionel-msft]

Hi @Anonymous ,

Please provide a sample .pbix file.
Regarding the error of the total of the measure, we need to modify the formula according to the data model.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you Ibend / V-lionel. I added a file to Dropbox with file link. I am not sure if this will work. Let me know if there is a better alternative to share the file.

Thank you once again.

https://www.dropbox.com/s/3lopbw8z40nbh8n/Dashboard%20Margin%20Scorecard.pbix?dl=0

[lbendlin]

Please provide sample data in usable format (not as a picture) and show the expected outcome.