Hi hopefully this makes sense.
I am trying to prepopulate a filter based on the users last input selected. The rows in my dataset have a staring city location and an ending city location to get possible routes. The first method I tried was to join every starting location on every ending location and then from there join rows that have Starting Location = Previous ending Location causing the dataset to grow exponentially. Example of the rows "(Column name: Route One) ATL → LOS (Column Name: Route Two) LOS → CHI" "(Column name : route one)ATL - LOS (Column Name : Route Two) LOS → LAS" The next option I tried was just to have one column name with every single possible route and use the DDX Brick called Searchable Filter APP witch works but it doesnt filter based on users last input. My thought is the only way to make this possible is to just have that massive dataset.
My Question is how can I make it where the same column is getting filtered "Route", without making the dataset be in the couple billions rows, and whatever the ending location is of the first route they select, is the starting location of the second route.