Forum Discussion

Livia_Hernandez's avatar
Livia_Hernandez
Icon for Helper I rankHelper I
2 years ago
Solved

Caclulating a cusomter count - help!

I'm new to this code writing....  I'm trying to sum the number of unique customer codes that enter in our stores.  I am coming up with a total by location but the region totals do not sum the stores....
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Livia_Hernandez ,

     

    Try the following formula which gets the cumulative value correctly.

    M1 = DISTINCTCOUNT('Table'[Customer])
    M2 =
SUMX (
    VALUES ( 'Table'[Product] ),
    CALCULATE ( DISTINCTCOUNT ( 'Table'[Customer] ) )
)

     

    Best Regards,
    Adamk Kong

     

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

gmsamborn's avatar
gmsamborn
Icon for Super User rankSuper User
2 years ago

Hi Livia_Hernandez 

 

Is it possible that a customer can be related to more than 1 StoreCode? 

 

In a case like that, each StoreCode would count that customer but that customer would only be counted once in the total.