Merge 2 selectedvalues from different tables

[robertvdleeuw]

I have a dataset containing sales of different stores, and am creating a report in which 2 stores can be selected and compared. 

The 'Current' and 'Comparative' slicers at the top left operate on 2 copies of the datatable containing all of the addresses, with no relations to any other tables. This way they don't interfere with one another.

What I want to do is to get both addresses showing in the map at the bottom left. I can get it to display one at a time easily, using the related zip code. But getting them both to show up has been quite a hassle so far, especially because merging the selectedvalues is harder due to the lack of relation between the tables. 

Is there a way to set up a measure containing both addresses, coming from these 2 selectedvalues?

[tamerj1]

Hi @robertvdleeuw 

To be honest I've never used the map visual therefore not sure how does it behave. I will assume it behaves the same way as a table. 
Create a table that contains all the locations and use it to build the map. 
create a filter measure following this template:

=
CALCULATE (
    COUNTROWS ( Location),
    TREATAS (
        {
            SELECTEDVALUE ( Current[Current] ),
            SELECTEDVALUE ( Comparative[Comparative] )
        },
        Location[Location]
    )
)

place this measure in the filter pane of map, select "is not blank" and apply the filter. 

[robertvdleeuw]

Hey, thanks for the response.

I filled in your measure with the revelant data, but unfortunately it doesn't seem to work. The 'Selections =/= blank' filter doesn't remove any of the other addresses - or any at all, for that matter. It does 'notice' the 2 selections, but I'm not sure if it actually contains those selections, based on this table:

[tamerj1]

Hi @robertvdleeuw 
I did some trials. This should work

=
CALCULATE (
    SELECTEDVALUE ( Location[Location] ),
    TREATAS (
        {
            SELECTEDVALUE ( Current[Current] ),
            SELECTEDVALUE ( Comparative[Comparative] )
        },
        Location[Location]
    )
)

Please place this measure in the filter pane and select "is not blank" and apply the measure

[robertvdleeuw]

Hey, thanks again for the help. I tried your new solution, but now 'Selections' is blank.

Here are the important tables regarding this question, if that helps:

Stores

Current/Comparative (They're identical)

If you need anything else, just let me know.