Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, how to count Name of handler that scored less than 90%
It returns a boolean.
Solved! Go to 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.
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.
Ayee thanks! Works like magic.
@xRTP , if Quality Rating score is a measure then
Countx(filter(values(Table[Name of handler]), [Quality Rating score] <.8 ) , [Name of handler])
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |