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...
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
Icon for Community Champion rankCommunity 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.