Count less than 90%

[xRTP]

Hello, how to count Name of handler that scored less than 90%

It returns a boolean.

[v-zhangti · Accepted solution]

Hi, @xRTP 

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.

[xRTP]

Ayee thanks! Works like magic.

[amitchandak]

@xRTP , if Quality Rating score is a measure then 

Countx(filter(values(Table[Name of handler]), [Quality Rating score] <.8 ) , [Name of handler])

[xRTP]

Hello,

It only returns 1, this is their quality everyday. The thing is i want to count how many times per handler they scored <80% in a month(slicer).