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

3 Replies

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