Forum Discussion

Vallt's avatar
Vallt
Frequent Visitor
1 year ago
Solved

DAX distinctcount with a condition

Hello,   I am new to DAX so I need help on this. To describe my problem simply I have a data table with first row "Item number", second row "customer number". For each sale of item XXXXX there is a...
  • xifeng_L's avatar
    xifeng_L
    1 year ago

    Can try the below calculated column expression:

     

    Result = CALCULATE(DISTINCTCOUNT('Table'[Customer number]),ALLEXCEPT('Table','Table'[Item number]))

     

     

    Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

     

    Thank you~

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

Vallt , Create a measure using

 

Number of distinct customers for this item =
CALCULATE(
DISTINCTCOUNT('YourTable'[Customer number]),
ALLEXCEPT('YourTable', 'YourTable'[Item number])
)