Is there a way to allow a user to search a DAX Concatenated measure for specific text.

[dmaddern]

Hello

I have a concatenated text string and users want to search the results for specific terms.

Here is the DAX Formula:

project1Just = "Project: "& MAX(tblProject1[Project1]) & UNICHAR(10) & UNICHAR(10) &"Salaries: "& max(tblProject1[personnel_just1]) & UNICHAR(10) & UNICHAR(10) & "Fringe: " & max(tblProject1[fringe_just1]) & UNICHAR(10) & UNICHAR(10) & "Equipment: " & max(tblProject1[equip_just1]) & UNICHAR(10) & UNICHAR(10) & "Travel: " & max(tblProject1[travel_just1]) & UNICHAR(10) & UNICHAR(10) & "Supplies: " & max(tblProject1[supply_just1]) & UNICHAR(10) & UNICHAR(10) & "Contracts: " & max(tblProject1[contract_just1]) & UNICHAR(10) & UNICHAR(10) & "Other: " & max(tblProject1[other_just1])

I tried the different Slicer options incl the "Microsoft Text Filter" and "OKVIZ" but i am not allowed to map a Measure to the Field. Only accepts a DATA field.

I have seen other DAX solutions but not one that allows the user to enter the text value (e.g. user enters 'Copier" to search the DAX formula above to find all instances of the word 'copier').

[Greg_Deckler · Accepted solution]

@dmaddern - I would suggest using the Filters pane, the Advanced filtering, Contains feature:

[dmaddern]

Hi again,

I am trying to use the Filters pane but the field is deactivated. All the other visualizations work with the Filter pane. This is occurring both in PBI Desktop and the Workspace where it is published.

Any suggestions why the filter pane is not working on this measure. It is displayed in a table.