Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hello, how to count Name of handler that scored less than 90%
It returns a boolean.
Solved! Go to Solution.
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.
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.
Ayee thanks! Works like magic.
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).
User | Count |
---|---|
101 | |
69 | |
58 | |
47 | |
47 |