Forum Discussion
Solved
Conditional distinct count dax
Hi, Request your help to create DAX for Distinct count of IDs against each Name rows in table. (desired result shown in last colunms) Name ID NO. DAX for Desired Result (Distinct ID ag...
DAX measure:
Distinct ID Count =
CALCULATE(
DISTINCTCOUNT(Table[ID NO.]),
ALLEXCEPT(Table, Table[Name])
)
This will give you the distinct count of ID NO. for each Name.
If this helped, a Kudos 👍 or Solution mark would be great!🎉
Cheers,
Kedar Pande
Connect on LinkedIn