topic Trying to map the difference in countries in DAX Commands and Tips

Trying to map the difference in countries

Anonymous — Mon, 14 Feb 2022 17:29:20 GMT

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

Re: Trying to map the difference in countries

amitchandak — Tue, 15 Feb 2022 04:31:54 GMT

Anonymous , You can use visual level filters ?

Re: Trying to map the difference in countries

Anonymous — Thu, 17 Feb 2022 07:12:15 GMT

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.