topic Re: Merge 2 selectedvalues from different tables in DAX Commands and Tips

Merge 2 selectedvalues from different tables

robertvdleeuw — Mon, 03 Oct 2022 12:40:06 GMT

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?

Re: Merge 2 selectedvalues from different tables

tamerj1 — Mon, 03 Oct 2022 14:14:15 GMT

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.

Re: Merge 2 selectedvalues from different tables

robertvdleeuw — Mon, 03 Oct 2022 15:25:21 GMT

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:

Re: Merge 2 selectedvalues from different tables

tamerj1 — Mon, 03 Oct 2022 16:02:26 GMT

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

Re: Merge 2 selectedvalues from different tables

robertvdleeuw — Tue, 04 Oct 2022 16:56:24 GMT

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.