Forum Discussion

sutmar's avatar
sutmar
Frequent Visitor
8 years ago
Solved

Show items with text field based on selected text

I have a list of Projects in a table [Projects] with a column [DSF] containing text. I created another table [Select] with a Column listing words that shall be used as a filter. I would like to diaply all Projects that contain selected word in column [DSF]. Until now I have failed to achieve this and would appreciate suggestions. 

  • v-haibl-msft's avatar
    v-haibl-msft
    8 years ago

    sutmar

     

    You can create two measures with following DAX formula, one to return the selected text, another one to mark the filtered rows.

    For details, please refer to attached PBIX file.

     

    SelectedString = 
IF (
    ISFILTERED ( Table2[DSF_Select] ),
    SELECTEDVALUE (
        Table2[DSF_Select],
        CONCATENATEX ( Table2, Table2[DSF_Select], ", " )
    ),
    "Not Select"
)

    Mark = 
SEARCH ( [SelectedString], CALCULATE ( MAX ( Table1[DSF] ) ), 1, -1 )

    Drag the Mark measure to visual level filter of the Table visual as following screenshot, set it greater than 0.

     

     

    Best Regards,
    Herbert