Forum Discussion
Getting Distinct Count for only certain values based on values in another column
Hello all, I have a table that looks something along the lines of this: ID Status Number 100 1 100 2 100 ...
Hello Anonymous
Here is a measure that should do what you want:
Distinct IDs Status not 2,5,7 = CALCULATE ( DISTINCTCOUNT ( YourTable[ID] ), NOT YourTable[Status Number] IN { 2, 5, 7 } )Does that work for you?
Regards,
Owen
Hello Anonymous
Here is a measure that should do what you want:
Distinct IDs Status not 2,5,7 =
CALCULATE (
DISTINCTCOUNT ( YourTable[ID] ),
NOT YourTable[Status Number] IN { 2, 5, 7 }
)
Does that work for you?
Regards,
Owen