Calculate the count of a measure in DAX

SUTChepe — Mon, 14 Aug 2023 22:41:48 GMT

Hi, I have a simple table for a Quality program, where I have a Measure:

QA Score = AVERAGE([Score])

This gives me the QA Score, but I want to make a DAX measure that calculates all the QA Score that are above or equal 90%, I tried doing several but I always have errors counting others or not counting all, the latest example I have is:

On target: =CALCULATE(DISTINCTCOUNT([Name]),FILTER(Table_Name,[QA Score]>=0.9))

Weekly evaluation works fine as we only have 1 evaluation per agent, but the problem starts when we have more than 1 week as we have 1 evaluation above 90% and one lower than 90%, for example:

Evaluations

QA Score

On Target

85%

when having 2 evaluations:

But i would like the "on target" measure to calculate this based on the overall measure, not the individual evaluation performance, please let me know if it makes sense

Re: Calculate the count of a measure in DAX

tamerj1 — Tue, 15 Aug 2023 06:04:29 GMT

Hi SUTChepe

please try

On Target: =
SUMX ( VALUES ( Table_Name[Name] ), INT ( [QA Score] >= 0.9 ) )

Re: Calculate the count of a measure in DAX

SUTChepe — Mon, 21 Aug 2023 05:08:09 GMT

Worked like a charm

Never used the "VALUES" formula before

topic Calculate the count of a measure in DAX in DAX Commands and Tips

Calculate the count of a measure in DAX

Re: Calculate the count of a measure in DAX

Re: Calculate the count of a measure in DAX