Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Summing the Measures - I'm missing something

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.
 
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
 
Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

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

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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.