Measure showing wrong sum

[Anonymous]

Hello Community,

I created a measure to calculate the sum of total limit multplied by the count of batch numbers

Total Limit x Count of Batch Number =

SUM([Limite totale]) * COUNT('V_GPAI_PertesJus_Analyse'[Nombre de batch])

When I select one number it shows me the right value ( For example below 240, 350) 

But when I select both, normally it had to show me 590, unfortenatly it shows me 1180

Do you know How can I solve this problem ?

Thanks

[Anonymous]

It works 🙂 thanks @rodrigosan 

[rodrigosan]

Great.
Very honored to be able to contribute.
🙏🙏

[rodrigosan · Accepted solution]

Hi @Anonymous 
did you check that you do not have a number of repeated batches.
If this is your case, I suggest using DISTINCTCOUNT instead of COUNT.

[rodrigosan]

Hi @Anonymous 
did you check that you do not have a number of repeated batches.
If this is your case, I suggest using DISTINCTCOUNT instead of COUNT.