Edit Interaction feature At report level filters

[Narukkp]

Hi Team,

I am able to achive the below scenario using "Edit Intraction" feature but recently requirement has changed to all slicers are removed and put these slicers related columns in Report level filter. Now using Report level filter i am not able to achive the below scenario please guide me if you have any idea.

My scenario is I have 3 slicers like Country , State, city and 3 cards like Country Average Sales, State Average Sales and City Average Sales. So if i selected the City in slicer then value should change only in City card and not in Country , states related cards and if the same way i selected the the state in slicer then value should change in State card only and not in country, city related cards. I am able to achive this feature in existing report using "Edit Intraction " but now these slicers are removed from page and moved to Report Level filter panel. Now how i can achive this scenario using report level filter ?

[amitchandak · Accepted solution]

@Narukkp,

Interaction is not possible between filter pane and Visual. So you have to create measures as per need using all, if you need to avoid the interaction.

example

New Measure =calculate([Measure],All(Dim1))

New Measure =calculate([Measure],All(Dim1),All(Dim2))

[amitchandak · Accepted solution]

@Narukkp,

Interaction is not possible between filter pane and Visual. So you have to create measures as per need using all, if you need to avoid the interaction.

example

New Measure =calculate([Measure],All(Dim1))

New Measure =calculate([Measure],All(Dim1),All(Dim2))

[Narukkp · Accepted solution]

@amitchandak  thank you so much for giving  excelent idea. It is working  as expected when i am creating the measure .