Forum Discussion
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...
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
pxg08680
Resolver III
Resolver IIIGoing with the output directly, this works but not a suggested way.
Step1:
SLPIT YOUR DSF COLUMN IN TABLE1 USING COMMA DELIMITER. AND MAKE THESE NEW RELATIONSHIP BETWEEN THESE DSF SLPIT COLUMNS AND DSF_SELECT FROM TABLE2 AND JOIN THEM AS BELOW.
STEP 2: DROP YOUR DSF_SELECT COLUMN INTO SLICER AND SELECT ANY. SELECTING DSF1 YOU NEED TO GET POEJECTA INFO ONLY ACCORDING TO YOUR REQ.
THIS WORKS GOOD BUT LONG PROCESS AND NOT A SUGGESTED ONE.