Map with a measure - CONCATEX function

Hello,

Does anyone know the best way to concate / combine address information to create a full address to be used on the map visualization? The data that i am using has address, city, and zip split into multiple columns so the map visualization has some incorrect points because its searching only using the street address. I tried using the CONCATEX function to bring the columns together but i could not use this measure as a location for the map visual . Any guidance is appreciated.

Thanks,