Limiting or stopping further FILTER

Hi
I have been trying to develop some KPI targets in a retail setting with a number of shops. I have a number of measures like sales per shop, Premises cost as % of income. By ranking the shops by profitability I have also now been able to Filter all of these measures down to the high performing shops which I am setting as targets.

What I am struggling with now is how I ‘fix’ those measures so that when I put them into filters they don’t filter any further i.e when I filter by individual shops. I have used the ALL function in the past to remove all filters but is there an equivalent that stops any further filtering.

My workaround for this has so far been to have the ‘benchmarks’ as static cards and I have edited the interactions with the sliders to not change them any further. I then have the actuals next to the static cards and you can eyeball the difference.

I would really like to use the KPI visuals and since I need the visual to filter with the slide this is why I need to ‘fix’ or 'prevent further filtering of the target field for that visual.

So I am imagining the DAX formula looks something like this if I was calculating the Sales per shop (Total sales divided by number of shops) target by isolating last years performance of the high ranking shops.

Calculate (Sales per shop,
FiIter (dates, date(fiscalyear) = “2019”,
Filter (Sales, Sales(salesranking) = “High”
and then STOP… But what is this function?

I hope this has made clear what I am after. If anyone can steer me to the an area to go look at that might solve this I would really appreciate it.

Hi @AllanL, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.

  • Use the forum search to discover if your query has been asked before by another member.

  • When posting a topic with formula make sure that it is correctly formatted to preformated text </>.

  • Use the proper category that best describes your topic

  • Provide as much context to a question as possible.

  • Include demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

I also suggest that you check the forum guideline How To Use The Enterprise DNA Support Forum. Not adhering to it may sometimes cause delay in getting an answer.

Hi @AllanL

Based on the description and my understanding, you are already on the right track by using static Card visuals and stopping interaction with Slicers or using ALL/RemoveFilter DAX functions in Target measure to disable the affect of slicer.

There is no option to disable all Slicers access permanently other than Edit Interaction or using DAX function.

One thing you can try is putting Target values in a Calculated Table using DAX expressions and remove Relationship with the other tables. This will allow Target to remain static instead of filters. This may work but need more inputs like exact requirements, sample PBIX to test it out.

Hope, this is helpful. If you have any other specific query please ask.

Thanks
Ankit J

Hi @AllanL , did the response provided by @ankit help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!

Thanks to the contributors of this post. Due to the length by which this post has been active, we are tagging it as Solved. For further questions related to this post, please make a new thread.