Forum Discussion

deepali_garg's avatar
deepali_garg
Frequent Visitor
4 years ago
Solved

Filled Map not working properly

Hi All,  I have a dim table with state , county and zip code in it. When I am maping with Florida as a State and Washington as County., the map works properly and gives correct result whereas provi...
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    deepali_garg OK, well then the problem is in your data, it has truncated zip codes. So, one way to solve this would be to create a new DAX column like:

    zip_code = FORMAT(INT([zip_cd]),"00000")