Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
JoWingsGSE
Frequent Visitor

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

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?

 

October.png

2 REPLIES 2
v-tangjie-msft
Community Support
Community Support

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
Memorable Member
Memorable Member

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.