Trying to map the difference in countries

[Anonymous]

Hello,

I am trying to map countries where map 1 countries are not present in map 2. How would I create DAX for that?

In other words, you can see the blue dots in map 1 below, and I want to map countries where map 1 dots are not in map 2. So map 3 below should include countries like Canada, China, Chile and some european countries, since those blue dots are not present in map 2.

 

let's say 1st map's table is Table1[Country]

2nd map with red dots is Table2[Region]

and the new table will be Table2[Location].

[Anonymous · Accepted solution]

Hi @Anonymous ,

It is not enough for your table 2 to have a region column, table 2 should also have a country column so that it can be compared with the country column of table 1.

Table1

Table2

Then you can create visual level measure.

Measure = IF(MAX('Table1'[Country]) <>MAX('Table2'[Country]) ,1)

Add a filter to a report in Power BI - Power BI | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You can use visual level filters ?