Count all records above average

[Pbiuserr]

Hello,

I've got a column ResTime provided in seconds (should get it only from two statuses). I need to capture all rows being above average of ResTime for these

Can someone have a look at that and say if its properly written?

My calculation is like down below

AboveAVG =

VAR MyAvg = CALCULATE(

AVERAGE('data'[RES_TIME]), ALL('data'[RES_TIME])

)

RETURN

IF(

ISBLANK(

CALCULATE(COUNTROWS('data'), FILTER('data','data'[RES_TIME] > MyAvg))),"N/A"

,CALCULATE(

COUNTROWS('data'),

FILTER('data','data'[RES_TIME] > MyAvg)))

[amitchandak]

@Pbiuserr , Simply try

AboveAVG =
VAR MyAvg = CALCULATE(
AVERAGE('data'[RES_TIME]), ALL('data'[RES_TIME])
)
return CALCULATE(
COUNTROWS('data'),
FILTER('data','data'[RES_TIME] > MyAvg))