Total not summing up correctly for months

Hi yo_ga ,

When I use the matrix visual, I could get the sum of monthly data contained in different years in my data table.

Or you could create a measure to calculate, we could get the same result.

Could you please provide example data or sample files here if you have any confused? And what you expect the output to be. There is sensitive data that can be removed in advance. How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.

Best regards,

Lucy Chen

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