Forum Discussion

dylanndengu's avatar
dylanndengu
Icon for Helper I rankHelper I
5 years ago
Solved

Make Customer Count Column using Distinct Values

Hi Everyone,   I am having a bit of trouble creating a customer count column based on the below information:     Essentially, I would like a column where customer count is equal to 1 if th...
Need Help
Tips and Tricks
Tutorial Requests
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi dylanndengu ,

     

    You can use the following measure :

     

    Measure = SUMX(SUMMARIZE('Table','Table'[report date],'Table'[sold date],"countofcustomer",DISTINCTCOUNT('Table'[document])),[countofcustomer])

     

    Sample data:

    Result:

     

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

     

    Best Regards,

    Dedmon Dai

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

dylanndengu , nor very clear , Try measure like

 

Distinctcount(Table[documentnbr])

or

 

Countx(summarize(Table, Table[reportdate], table[soldate], "_1",Distinctcount(Table[documentnbr])),[_1])