Forum Discussion

longlostlives's avatar
longlostlives
New Member
5 years ago
Solved

Filter Locations by Related Location

I have a table that stores locations that have been selected in a particular session. Here is some example data:   Session ID Location Location ID 1 Washington 1 1 Dallas 2 2 Was...
Need Help
  • longlostlives's avatar
    longlostlives
    5 years ago

    I ended up setting up a table in Power Query to contain all the required data instead of going the DAX route. It does the job and will monitor performance vs. trying again in DAX.

longlostlives's avatar
longlostlives
New Member
5 years ago

Greg_Deckler Thanks for the tip! I am able to get the selector working to display the results in a table, but I'm having trouble making it work when I try to count the Session ID for the map size parameter.

 

Here's what I have for the 'basic' selector:

Related Locations = 
VAR LocationID = MAX([LocationID])
VAR Location = MAX([Location])
VAR LocationSelected = VALUES(Locations[Location])
VAR TableSelected = SELECTCOLUMNS(FILTER(ALL(LocationCities), [Location] IN LocationSelected), "LocationID", [LocationID])
RETURN
IF (LocationID IN TableSelected && Location <> LocationSelected, 1, BLANK())

Any thoughts on how to modify this or set up another measure to use this to determine how many times each related location shows up?