Count distinct values as a measure

[Nita]

I have column of NPS Score from 1-10. I am trying to group them as detractor (1-6), Passive(7-8) and Promoter(9-10) in a measure. Then I want to display is pie chart. I have this: 

Detractor = CALCULATE(COUNT('Aug'[NPS] < 7)) but it says count accepts a column reference as an argument.

AT the same time, I need to count only distinct user ID.

Thanks

~Nita

[Jimmy801]

Hello @Nita 

try this

Measure = CALCULATE(count('Aug'[NPS] ),filter('Aug','Aug'[NPS] <7))

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[Nita]

Thanks Jimmy, this kind of meets my need. I have another ID column. I want to count on the values of NPS for distinct ID values only!

[Jimmy801 · Accepted solution]

Hello @Nita 

then try this

Measure = CALCULATE(DISTINCTCOUNT('Aug'[name] ),filter('Aug','Aug'[NPS] <7))

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[Nita]

Thanks Jimmy. Have a good day!