Something strange is happening with my measure and I can't figure out why / what I need to do to make it work properly. Any advice would be great. I have a table, simplified below, and on the page there is a slicer for country. I am using a table visual to display the items for the selected country and also price, with the correct currency.
My measure currently looks like this, where Measure1 is a simple average(price) measure. When I add this measure as a field to the table visual it displays the items from all countries, just with blanks in this column.
VAR SelectedCountry =
I have tried using various filters but have had no success. Any ideas? 🙂