Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Trying to map the difference in countries

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.