Filter table with multiple logical conditions dynamically

Hello Anonymous,

Can you please try this approach:

1. Create a table for the slicer

SlicerTable = DISTINCT(financial[ColumnA])

2. Create a measure that applies your filtering logic dynamically

DynamicFilter = 
VAR SelectedValue = SELECTEDVALUE(SlicerTable[ColumnA])
RETURN
IF(
    (MAX(financial[ColumnA]) > SelectedValue && MAX(financial[ColumnB]) > SelectedValue) ||
    (MAX(financial[ColumnA]) = SelectedValue && MAX(financial[ColumnC]) = SelectedValue),
    1,
    0
)

Hope this helps.

Hi Anonymous ,

I want to acknowledge valuable input provided by Sahir_Maharaj  and rajendraongole1  . Their initial ideas help guide my approach. However, I noticed that more details are needed to fully understand this issue.

It is not possible to get the parameters of the slicer in the calculation table, this is due to the design, so I recommend that you create a table visual object for presenting the data.

(1) Create a slicer table.

SlicerValues = GENERATESERIES(1, 100, 1)

(2) Create a measure.

Flag = 
VAR SelectedValue = SELECTEDVALUE(SlicerValues[Value])
RETURN
IF(
    (MAX(financial[ColumnA]) > SelectedValue && MAX(financial[ColumnB]) > SelectedValue) ||
    (MAX(financial[ColumnA]) = SelectedValue && MAX(financial[ColumnC]) = SelectedValue),
    1,
    0
)

(3) Create a form visual object and set up filtering on the visual object.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.