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 oper...
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

     

    • robertvdleeuw's avatar
      robertvdleeuw
      Frequent Visitor
      3 years ago

      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.