Forum Discussion
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 values for the stores above.
I want the KPI visual to filter by "Store4" when no store is selected from the bar chart but when a store is selected from the bar chart, I want the KPI visual to filter for that specific store.
Is it possible?
Thank you!
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)
1 Reply
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)