Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Thank you in advance.
Solved! Go to 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.
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.
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |