Complex Conditional filtering

[ech12]

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!

[GilbertQ · Accepted solution]

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)