Selected value to change to the second filter

[Tlotly]

Good day.

I have two slicers, Region and Zone.  Region is the highest level to Zone i.e. 1 region has multiple zones. Currently, I can display either the selected region or the zone on my card visual, which is perfect.

But if both are selected at the same time, I need to display the lowest level only which isthe zone. Is there a way to do this?

Dax for the measure: 

Measure 3 = var _region = SELECTEDVALUE(Query1[Region Description])

           var _zone = SELECTEDVALUE(Query1[Zone Description])

            var _branch = SELECTEDVALUE(Query1[Branch Name])

return if(ISFILTERED(Query1[Region Description]), _region,

           if(ISFILTERED(Query1[Zone Description]),  _zone,

            if(ISFILTERED(Query1[Branch Name]), _branch

           ," ")))

Thank you in advance.

[Adescrit · Accepted solution]

Hi @Tlotly 

I think you can change the order of the IF statement slightly to make this work as you want

Measure 3 = var _region = SELECTEDVALUE(Query1[Region Description])
           var _zone = SELECTEDVALUE(Query1[Zone Description])
            var _branch = SELECTEDVALUE(Query1[Branch Name])
return if(ISFILTERED(Query1[Zone Description]), _zone,
           if(ISFILTERED(Query1[Region Description]),  _region,
            if(ISFILTERED(Query1[Branch Name]), _branch
           ," ")))

This way it will check if a zone has been selected first, and if so display the selected zone.

[Tlotly]

@Adescrit  thank you very much. It works perfectly.