Use measure to filter slicer or pass values to table to be used as slicer

[Anonymous]

I have a measure that calculates the distance between two sets of GPS coordinates. 

I then have a parameter setup and table of distances (0-25) used as a slicer to determine the "range" I would like to see (ex. shows results of all entities within "x" miles of target entity). 

And finally, a measure that determines whether or not all entities are within range of the target entity.

IsInRangeImp = If([DistanceImpala]<=MAX('Distance'[Distance Away]),1,0)

IsInRangeImp showing entities within 1 mile of target entity.I am able to use the IsInRangeImp measure as a visual level filter on a map and table, as well as the logic in measures for cards, but per Power BI's limitations I am not able to use this measure in a slicer.  If 20 entities show up within the specified distance, the user needs to be able to filter them down to the 3-5 they would like to visualize.  How can I use this measure that is dynamically calculating distance to filter a slicer list down?

Side note, I am not able to use this IsInRangeImp measure on scatter charts or line graphs, as even when used as a visual level filter it will throw a 1M row error (my dataset has 120B rows) when I know there are < 100k rows for the entities within range.

Please help!

BIPowerUser

[v-yulgu-msft]

Hi @Anonymous,

 As of now, it is not supported to add a measure into "Visual/Report/Page level filter" to filter slicer. Here is an idea for you to upvote.

Best regards,

Yuliana Gu

[Anonymous]

Thanks @v-yulgu-msft  - I am aware of the limitation, which is why I am looking for a workaround like one of these:

Using Measure in Calculated Column (did not work for me)

https://www.fourmoo.com/2018/07/10/creating-a-slicer-that-also-contains-a-dax-measure/

Using R script to write to SQL DB (could not get to work)

https://www.youtube.com/watch?v=3QiTBXfxzHA

Any and all creative ideas welcome!