Forum Discussion
Distance Filter on Measure with Placeholder error
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..
Anonymous , 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]))
1 Reply
Anonymous , 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]))