Distance Filter on Measure with Placeholder error

[billuran2009]

I have a formula

Distance (MI) =

7917.5 -- The diameter of the Earth (KM).

* ASIN (

-- Returns the arcsine, or inverse sine, of a number.

SQRT (

-- Returns the square root of a number.

POWER (

-- Returns the result of a number raised to a power.

SIN ( -- Returns the sine of the given angle.

MAX(PateintDetailsViewActive[LATP]) - MAX(PateintDetailsViewActive[LocLAT]) )

* PI () / 360,

2

) -- PI () Returns the value of Pi, 3.14159265358979, accurate to 15 digits.

+ COS (

-- Returns the cosine of the given angle.

MAX(PateintDetailsViewActive[LATP]) * PI () / 180

)

* COS (Max(PateintDetailsViewActive[LocLAT]) * PI () / 180 )

* POWER (

SIN (Max(PateintDetailsViewActive[LNGP]) - Max(PateintDetailsViewActive[LocLNG]) )

* PI () / 360,

2

)

)

)

I want to use this formula to filter out account numbers where the distance is greater then 25

I used

Potential IOP = calculate(COUNTROWS(PateintDetailsViewActive),MeasureTable[Distance (MI)]<26)

but get an error 

 A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

ANy help would be appreciated. Or if I can write my meausre power query that would easy too..

[amitchandak · Accepted solution]

@billuran2009 , Try if one of the two can help (Based on what I got)

calculate(Countx(Filter(Values(PateintDetailsViewActive[Account ID]),[Distance (MI)]<26),PateintDetailsViewActive[Account ID]))

calculate(Countx(Filter(PateintDetailsViewActive,[Distance (MI)]<26),PateintDetailsViewActive[Account ID]))