Sum is showing data for multiple years, not the one selected

[JoWingsGSE]

Hi helpful people!

I have a large set of data that covers transactions from 2018 to date. I am trying to filter this on my report to display only the month of October 2023 but it seems to be showing the cumulative amount for all years despite being drilled down.  It should be around the £220k mark, not £2m!

Is there anything glaringly obvious from the below that I am missing?

[v-tangjie-msft]

Hi @JoWingsGSE ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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

[lukiz84]

can you show the relevant tables + relationships and the code of measure "sum of nett sales"?