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
Icon for Microsoft Employee rankMicrosoft 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

 

Could the setting be adapted that I see all the projects if no value is selected? And would it possible to allow multiple filter values?