Need to find what % of a column's values are < a target value

[Anonymous]

I'm having trouble writing a measure to find what % of a column's values are less than (<) a target value.

This is what I have thus far...but i'm off somewhere.

Measure = Calculate(PERCENTILE.INC(Tbl_RigData[ERS Total Response Time], FILTER(Tbl_RigData, <= 420)

[GustavoSF]

Hello William,

Normally for these cases, I create a VAR for the numerator and another for the denominator, and then I just divide them.

For example, I would do:

MEASURE =

VAR denominator = COUNTROWS(Tbl_RigData)

VAR numerator = CALCULATE(COUNTROWS(Table), Table[ERS Total Response Time] <= 420)

RETURN

     DIVIDE(numerator, denominator)

PERCENTILE.INC works oppositely, you provide it with the percentile and it returns values that are in that specified percentile.