Measure to show chosen slicer Or drill through on a map. Measure only shows Filter not map selection

[DebbieE]

I have a slicer on Region.

And a card to show what I have selected on distric which works via a measure

Region For Card =

IF (

ISFILTERED ( 'dim Location'[Region] ),

MAX ( 'dim Location'[Region] ),

"No Region Selected"

)

So if no region is selected it says No Region Selected and if you select a region it shows here.

However under this card I also have a map. It contains region and you can drill through to postocde.

With No Region set in the slicer I can select a region on the map e.g. West Yorkshire but because its done via the map and not the slicer the Card still shows No Region Selected.

Obviously I The measure is about filtering. Is there anyway I can change the measure to allow it to show results from the slicer OR the Map selection?

[DebbieE]

Very odd, it doesnt appear to be working. 

Region(Map) for card =

IF(SELECTEDVALUE('dim location'[Region]),

MAX('dim location'[Region]),

"Region")

It all fine when Ive not clicked on a region on the map but when I click on a region it still just says region

[calerof · Accepted solution]

Try this:

Region(Map) for card = SELECTEDVALUE( 'dim location'[Region], "No Region Selected" )

[DebbieE]

Yey it worked. Thank you all

[calerof]

Hi @DebbieE 

Try to use SELECTEDVALUE instead in your function.

https://docs.microsoft.com/en-us/dax/selectedvalue-function

Regards,

Fernando