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!

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

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'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!