cancel
Showing results for
Did you mean:
Helper I

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..
1 ACCEPTED SOLUTION
Super User

@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]))

Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!
Super User

@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]))

Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

Announcements

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!