Forum Discussion

JeffreyH's avatar
JeffreyH
Regular Visitor
3 years ago
Solved

Report Builder DAX query search

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 Rep...
  • AnthonyGenovese's avatar
    AnthonyGenovese
    3 years ago

    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!

JeffreyH's avatar
JeffreyH
Regular Visitor
3 years ago

This did not work.  

Here's the error that was returned to me

 

 

AnthonyGenovese's avatar
AnthonyGenovese
Icon for Resolver III rankResolver III
3 years ago

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!