Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

 

 

Need Help
  • rodrigosan's avatar
    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.

4 Replies

    • rodrigosan's avatar
      rodrigosan
      Responsive Resident
      4 years ago

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

  • rodrigosan's avatar
    rodrigosan
    Responsive Resident
    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.

  • rodrigosan's avatar
    rodrigosan
    Responsive Resident
    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.