Measure not giving the value proper:

[madhushree]

Measure not giving the value proper:
I have used below measure to calculate the revenue based on year-month field.
Price = sum('table'[amount])
And it is giving me wrong result!!
Below screenshot shows what exactly i needMeasure not giving the value proper:
I have used below measure to calculate the revenue based on year-month field.
Price = sum('table'[amount])
And it is giving me wrong result!!

Here price is getting doubled sometimes dont know why?!!

Can anyone help me with this.

[madhushree]

Hi All, Thanks for the fast reply.. I checked in source there were duplicate records for same date in source itself!

[v-ljerr-msft · Accepted solution]

Hi @madhushree,

Great to hear the problem got resolved! Could you accept your reply above as solution to close this thread? 

Regards

[v-ljerr-msft]

Hi @madhushree,

Could you post your table structures with some sample data which can help reproduce this issue? So that we can help further investigate on it. It's better to share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards