Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Count less than 90%

Hello, how to count Name of handler that scored less than 90% It returns a boolean.
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Anonymous 

     

    Measure:

    Quality<90 = 
CALCULATE (
    COUNT ( 'US RAW'[Name of Handler] ),
    FILTER ( ALL ( 'US RAW' ), [Quality Rating Score] < 0.9 )
)

    Based on the sample data you provided, is it what you expected to get such a result?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, Anonymous 

 

Measure:

Quality<90 = 
CALCULATE (
    COUNT ( 'US RAW'[Name of Handler] ),
    FILTER ( ALL ( 'US RAW' ), [Quality Rating Score] < 0.9 )
)

Based on the sample data you provided, is it what you expected to get such a result?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Ayee thanks! Works like magic.