Forum Discussion

robertvdleeuw's avatar
robertvdleeuw
Frequent Visitor
3 years ago

Merge 2 selectedvalues from different tables

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?

4 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    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's avatar
      robertvdleeuw
      Frequent Visitor
      3 years ago

      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's avatar
        tamerj1
        Community Champion
        3 years ago

        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