Use Slicer's selected value as a filter for a UNION calculated table

[olimilo]

We have 3 calculated tables, Tables 01 and 02 references the data from CityGPS table while table 03 is supposed to combine the contents of 01 and 02 based on the single selected value of a slicer. However, Table 03 is only returning a blank table which I think is caused by the filter context - is there a way for us to use the slicer value as a filter for the UNION table? Does Table 01 and 02 being calculated tables (and not "actual" table) have any bearing to this?

Tables
01 StartPoint = 
    SELECTCOLUMNS(
        CityGPS,
        "City", CityGPS[City],
        "Latitude", CityGPS[Latitude],
        "Longitude", CityGPS[Longitude],
        "Country", CityGPS[COUNTRY]
    )

02 EndPoint = 
    SELECTCOLUMNS(
        CityGPS,
        "City", CityGPS[City],
        "Latitude", CityGPS[Latitude],
        "Longitude", CityGPS[Longitude],
        "Country", CityGPS[COUNTRY]
    )

03 CombinedTable = 
    VAR StartCity = SELECTEDVALUE('01 StartPoint'[City])
    VAR DestinationCity = SELECTEDVALUE('02 EndPoint'[City])
    
    RETURN
        UNION(
            SELECTCOLUMNS(
                FILTER('01 StartPoint', '01 StartPoint'[City] = StartCity),
                "City", '01 StartPoint'[City],
                "Type", "Start City"
            ),
            SELECTCOLUMNS(
                FILTER('02 EndPoint', '02 EndPoint'[City] = DestinationCity),
                "City", '02 EndPoint'[City],
                "Type", "Destination City"
            )
        )

[danextian]

Hi @olimilo 

That is not possible. Calculated tables update when the underlying data or the formula itself has been modified or during a refresh. It isn't aware of any slicer selection.

[olimilo]

Is there a different approach that can be done that would emulate the same result?