Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
Hello, how to count Name of handler that scored less than 90%
It returns a boolean.
Go to Solution.
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?
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.
View solution in original post
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])
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).
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.