Report Builder DAX query search

[JeffreyH]

Hello,

This is my first report using Power Bi Report Builder.

The question I am asking for assistance with is with DAX basically.

I created a query:

EVALUATE SUMMARIZECOLUMNS('Capital Pojects Report'[Reserved], 'Capital Pojects Report'[Product Name], 'Capital Pojects Report'[Product Description], 'Capital Pojects Report'[Goal],
FILTER(VALUES('Capital Pojects Report'[Product Name]), SEARCH("MERRC", 'Capital Pojects Report'[Product Name], 1, 0) > 0))

What I would like to add:

I would like to have both "MERRC" and "MERRD" to the retrevial. 

[AnthonyGenovese]

Is this what you are looking to do?

EVALUATE SUMMARIZECOLUMNS('Capital Pojects Report'[Reserved], 'Capital Pojects Report'[Product Name], 'Capital Pojects Report'[Product Description], 'Capital Pojects Report'[Goal],
FILTER(VALUES('Capital Pojects Report'[Product Name]), OR(SEARCH("MERRC", 'Capital Pojects Report'[Product Name], 1, 0) > 0),SEARCH("MERRD", 'Capital Pojects Report'[Product Name], 1, 0) > 0)))

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!

[JeffreyH]

This did not work.  

Here's the error that was returned to me

[AnthonyGenovese · Accepted solution]

Sorry, try this

EVALUATE
SUMMARIZECOLUMNS(
'Capital Pojects Report'[Reserved],
'Capital Pojects Report'[Product Name],
'Capital Pojects Report'[Product Description],
'Capital Pojects Report'[Goal],
FILTER(
VALUES( 'Capital Pojects Report'[Product Name] ),
OR(
SEARCH(
"MERRC",
'Capital Pojects Report'[Product Name],
1,
0
)
> 0,
SEARCH(
"MERRD",
'Capital Pojects Report'[Product Name],
1,
0
)
> 0
)
)
)

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!