Incorrect Total w/ Sample File

[Kurt4597]

Hi all, 

https://www.dropbox.com/s/95pgkz6k1np28qr/Sample%20File.pbix?dl=0

Currently experiencing an issue with calculating the total revenue in this table. I have provided a dropbox link to the sample PowerBI file to get a clearer picture of what is going on

Total Revenue shown as £3,650. However it is incorrect. It should be £1,470 + £1,728 + £408 = £3,606

 -Month end sales forecast is simple the (number of sales / current day in the month) * number of days in month. This creates a simple straight line forecast for end of month sales. 

- Each provider has a set CPA that does not change. I have a CPA table but was unable to bring in each value so, I simple appended the CPA table to the sales table and just used an "Average" of the CPA to get the same result. I believe this could be where the issue is being caused

-Revenue = CPA * Month End Sales Forecast

Any help would be greatly appreciated as I have been stuck on this issue for a few days and am unable to fix the issue

Thank you all!

https://www.dropbox.com/s/95pgkz6k1np28qr/Sample%20File.pbix?dl=0

[HotChilli · Accepted solution]

This is just a quick suggestion:

RevenueTest = SUMX(VALUES(Sales[ProviderName]), [Revenue])

I think I would probably have provider in a dimension table too but see how you get on testing this

[Kurt4597]

Thanks a lot buddy