Measure showing wrong sum

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

rodrigosan
4 years ago
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.

Forum Discussion