Filter 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