Calculate the base count of a column (for unique IDs only)

[peterknowlton]

Hello,

I'm trying to create a base count of a specific column but without counting the duplicate IDs multiple times. Thanks!

[vapid128 · Accepted solution]

Measure = CALCULATE(DISTINCTCOUNT('Table'[ID]),'Table'[speciific colnum]="xxx")

[peterknowlton]

Thank you!