Create a filter in a parameter selection

[rk1904]

I have a parameter with column A, column B, column C and I want to make a filter to the table depending on the chosen parameter

for example if I choose column A I want > 20, if I choose column B I want > 100, if I choose column C I want < 0.5

ID    column A     column B      column C

1          10                110               0.5              

2           5                 250               0.3                      

3           25                 2                 0.7                    

[Anonymous · Accepted solution]

Hi @rk1904 ,

Please try below steps:

1. below is my test table

Table:

2. add a field parameter with slicer

3. create a measure with below dax formula

MEASURE =
VAR tmp =
    SELECTCOLUMNS ( Parameter, "PT", [Parameter] )
VAR _str =
    CONCATENATEX ( tmp, [PT] )
VAR _a =
    SWITCH (
        TRUE (),
        COUNTROWS ( tmp ) = 3, 1,
        CONTAINSSTRING ( _str, "Column A" ), IF ( SELECTEDVALUE ( 'Table'[Column A] ) > 20, 1 ),
        CONTAINSSTRING ( _str, "Column B" ), IF ( SELECTEDVALUE ( 'Table'[Column B] ) > 100, 1 ),
        CONTAINSSTRING ( _str, "Column C" ), IF ( SELECTEDVALUE ( 'Table'[Column C] ) < 0.5, 1 )
    )
RETURN
    _a

4. add a Table visual with field and add measure to the table visual filter pane  and configure

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.