PowerBi Dashboard - display value based on Slicer Selection

[Anonymous]

Hi Folks,

I am new to the forum, please excuse if I didn't follow any of the group etiquette.

I need help with below scneario

in Slicer I have values Apple, Orrange & lemon, when I select Apple I need to display store A on the dashboard.

similary select Orrange I need to display store B on the dashboard and Lemon selection to show store C.

Please help me with the solution.

[amitchandak]

@Anonymous ,

New Meausre  =

Var _sel = selectedvalue(Slicer[Slicer], "Apple")

var _filter = Switch(_sel,

"Apple", "Store A",

"Orange", "Store B",

"Lemon", "Store C")

Return

calculate(Sum(Table[Value]), Filter(Table, Table[Store] in _filter ) )

//or you can use =

calculate(Sum(Table[Value]), Filter(Table, Table[Store] =  _filter ) )