Forum Discussion

epelton's avatar
epelton
Helper I
3 years ago
Solved

Field Parameter Filtering

I have a table with the bit columns shown in the socioeconomic slicer below - Minority Business, Small Business, etc. I've created Field Parameters to accomplish this (thanks amitchandak)   Vet Own...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi epelton ,

    According to your description, here's my solution. Create a measure.

    Measure =
VAR __SelectedValue =
    SELECTCOLUMNS (
        SUMMARIZE ( Parameter, Parameter[Parameter], Parameter[Parameter Fields] ),
        "Parameter", Parameter[Parameter]
    )
RETURN
    IF (
        COUNTROWS ( __SelectedValue ) > 1,
        1,
        IF (
            __SelectedValue = "Vet owned small business"
                && MAX ( 'Table'[Vet owned small business] ) = "True"
                || __SelectedValue <> "Vet owned small business",
            1,
            0
        )
    )

    Put the measure in the visual filter and select "is 1". Get the correct result:

    I attach my sample below for your reference.

     

    Best regards,

    Community Support Team_yanjiang

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

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi epelton ,

According to your description, here's my solution. Create a measure.

Measure =
VAR __SelectedValue =
    SELECTCOLUMNS (
        SUMMARIZE ( Parameter, Parameter[Parameter], Parameter[Parameter Fields] ),
        "Parameter", Parameter[Parameter]
    )
RETURN
    IF (
        COUNTROWS ( __SelectedValue ) > 1,
        1,
        IF (
            __SelectedValue = "Vet owned small business"
                && MAX ( 'Table'[Vet owned small business] ) = "True"
                || __SelectedValue <> "Vet owned small business",
            1,
            0
        )
    )

Put the measure in the visual filter and select "is 1". Get the correct result:

I attach my sample below for your reference.

 

Best regards,

Community Support Team_yanjiang

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