Forum Discussion
Helper IFilter a table visual based on a slicer selection
Hey Aklys ,
I'm. not sure if I understand your question correctly, but I will give it a try ...
I have a very simple table like the one below:
Now I want to filter for the rows that have a SalesAmount larger than or equal to 100M. For this I define a "check measure". This measure returns 1 if a condition is met, BLANK if not. The below shows the DAX of this check measure:
SalesAmount (more than 100M) = IF( [SalesAmount (ms)] >= 100000000, 1, BLANK() )Then I this measure on the filter pane for the visual:
When I hit "Apply filter", the table visual only shows the expected rows.
I use this technique quite often, of course you have to make sure that performance of this measure is good 😉 Sometimes it requires some more thinking because the "check-measure" is utilizing the filter context of the row. But I use this because the check-measure or the base measure (here it is SalesAmount (ms) ) do not have to be part of the data in the table visual.Hopefully, this gives you an idea of how to tackle your challenge.
Regards,
Tom
Hi Aklys ,
According to the post link, it seems that your issue has been resolved by our engineer.
Please mark the helpful reply if your issue has been resolved. Then more people who have similar issues like yours could see it.
Best Regards,
Rico Zhou
Super UserHi Aklys
That is not possble. Calculated tables or any other physical tables are stored in-memory and update only upon a refresh or the underlying data or the formula is modified. Whilen you can use a measure to create a calculated table, it is as if the measure isn't filtered at all. Table view affects the report view but not the other way around.
Helper IYeah I had thought as much. I was hoping there was some other method someone may suggest I hadn't realised was available to utilise the user's slicer selection. Like a measure creating a new ephemeral table or something that I can display in the table visual. But it seems not by your explanation. Thanks for your response.
- danextian
I was there ages ago.
I would create a separate post and not oversimplify my requirements, provide workable sample data (not an image) and the expected result from that.
- Aklys
I usually do that, but in this situation it's a lot of work for likely the same result of what you just stated, hence the simplification. If no one knows of a method to utilise a user selection from a data populated choice, to be used in a creating a calculated value that can be used to filter a visual, then the work to give a demonstration is a moot point. lol
