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.

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , if Quality Rating score is a measure then 

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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).

  • 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.