I have two tables: (1) designated market area(DMA) which contains data for mapping the USA at DMA level, (2) a second table that measures and dimensions at the DMA level. I could not join them because the data size explodes. So, I want to use data blending. I have LOD expressions as shown in the attached workbook. The map works fine but when I try to add a dimension to be used as filter, it fails. In the attached workbook, I want to add 'Site' and 'Market Name' as filters where the user can choose and the map should update based on the selection. Any help highly appreciated.
In case there is anyone who has the same issue, I solved the problem using parameters.