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 diapl...
  • 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

  • sutmar's avatar
    sutmar
    8 years ago

    v-haibl-msft

     

    Fantastic! Thank you so much, that is it! :-) Very much appreciated!

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
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

sutmar's avatar
sutmar
Frequent Visitor
8 years ago

v-haibl-msft

 

Fantastic! Thank you so much, that is it! :-) Very much appreciated!