Forum Discussion
Solved
Complex Conditional filtering
Hello everyone, One of my columns looks like the one below and I use it to filter my visuals. STORES Store1 Store2 Store3 Store4 I have a bar chart and a KPI visual, both showing valu...
Hi there, what you could do is to create this measure below.
Measure = SELECTEDVALUE(Table1[STORES],"Store4")
What this will do above is return the selected value, if nothing is selected it will then return Store4
What you could do is put this into a Variable "VAR" in your measure, and then reference this variable. Here is an example below.
My Second Measure = VAR StoreSelection = SELECTEDVALUE(Table1[STORES],"Store4") RETURN CALCULATE([Sales Amount],'Mytable'[Store Name] = StoreSelection)
GilbertQ
Super User
Super UserHi there, what you could do is to create this measure below.
Measure = SELECTEDVALUE(Table1[STORES],"Store4")
What this will do above is return the selected value, if nothing is selected it will then return Store4
What you could do is put this into a Variable "VAR" in your measure, and then reference this variable. Here is an example below.
My Second Measure = VAR StoreSelection = SELECTEDVALUE(Table1[STORES],"Store4") RETURN CALCULATE([Sales Amount],'Mytable'[Store Name] = StoreSelection)