Forum Discussion
deepali_garg
4 years agoFrequent Visitor
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...
- 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")
Greg_Deckler
4 years agoCommunity Champion
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")deepali_garg
4 years agoFrequent Visitor
Thank you Greg_Deckler . This one helped me and resolved my issue.
Have a great day !