Total of different month no adding up correctly

[Anonymous]

Hi,

I have a table made up of calculated measure. When I filter in months, the total is not adding up. My first guess is that the total is correct without month filter. But when you filter both months (January and February), the different amount does not add up to what in the total is without filter. see picture. 

I have spend much time trying to fix it but without any success. Can anyone help me with this 

[v-gizhi-msft · Accepted solution]

Hi,

Please try this measure:

New Measure = SUMX(DISTINCT('DATE'[MonthName]),origin measure formula)

Hope this helps.

Best Regards,

Giotto Zhi

[vanessafvg]

@Anonymous  what is the code for your total?  or is it just the sum of that fields.  Also what exactly are you trying to achieve, pleave provide a more indepth description it is hard to understand what you are asking for exactly by providing what you are expecting to see.  Also sharing a bit of dummy data will help people to help you solve your problem more easily.