Creating a measure to find % of an if statement

[water-guy-5]

Hello, I have some data that looks like this

Column A: expected $ amount
Column B: actual $ amount

My third column (Red Flag) is a calculated column that returns "Below Limit" when Column B is less than 75% of Column A, and looks like this (sometimes the columns are blank, hence my rather complicated expression for such a simple calculation)

Red Flag=

Var _A = Table[Actual]

Var _B = Table[Expected] * .75

return

IF( Table[Actual] = BLANK(), BLANK(),

IF( _A < _B, "Below Limit", BLANK()))

I am looking to write a measure that divides the amount of times "Below Limit" appears versus the total # of rows for the Red Flag calculated column, eseentially getting a % ratio for below versus all. 

Thanks in advance.

[water-guy-5 · Accepted solution]

I figured out a solution, and just posting here in case anyone is in a similar spot. 

I created another column that solves for the other result (when Actual is > 75% of Expected) that returns "Safe"

From there, I wrote this measure

Red Flag % =

Var _Below = CALCULATE(COUNT(Table[Red Flag]), Table[Red Flag] = "Below Limit")

Var _Safe = CALCULATE(COUNT(Table[Safe]), Table[Safe] = "Safe")

Return

DIVIDE(_Below, _Safe)