Calculate the count of a measure in DAX

[SUTChepe]

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
2	85%	1
		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

[tamerj1 · Accepted solution]

Hi @SUTChepe 

please try

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

[SUTChepe]

Worked like a charm

Never used the "VALUES" formula before