Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi peeps
Need your help in trying to work out a calulation for the overall passing quality score where the number of assesments met score is greater than and equal to 67% ([% of assessements met]).
Solved! Go to Solution.
Hi @Anonymous
It seems "staff passing quality" is a measure,
Then you could create a measure
Measure = COUNTX ( FILTER ( ALL ( Sheet1 ), [staff passing quality] <> 0 ), [staff passing quality] ) / CALCULATE ( DISTINCTCOUNT ( Sheet1[css name] ), ALL ( Sheet1 ) )
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Why should it be 67%. 7/24 is 29.16%.
=[Total assessments met]/[Total assessments]
Hope this helps.
Hi Ashish,
The 29.16% is correct for the 24 assesments that were carried out. But what i am after is how many CSS/staff passed quality ( in the table the is 5 people which should be 5/16 = 31.25% which is the total passing rate for the site)
Hi @Anonymous
It seems "staff passing quality" is a measure,
Then you could create a measure
Measure = COUNTX ( FILTER ( ALL ( Sheet1 ), [staff passing quality] <> 0 ), [staff passing quality] ) / CALCULATE ( DISTINCTCOUNT ( Sheet1[css name] ), ALL ( Sheet1 ) )
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |