Forum Discussion

IcingOnTheCake's avatar
IcingOnTheCake
Icon for Helper III rankHelper III
2 years ago

Do a select * for certain cases in DAX query

Dear Experts,  I need help for the bold red part please. Actually I would like to do a select all. Or to talk in sql: 'Product'[Product Hierarchy Level 2 Code] = *   How can I achieve that pleas...
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
2 years ago

Does this work?

 

[...]
FILTER (
    VALUES ( 'Product'[Product Hierarchy Level 2 Code] ),
    PATHCONTAINS ( @P_PL2, 'Product'[Product Hierarchy Level 2 Code] )
        || TRIM ( @P_PL2 ) = ""
)
[...]
  • IcingOnTheCake's avatar
    IcingOnTheCake
    Icon for Helper III rankHelper III
    2 years ago

    Thanks and "good idea"! It runs. But then again "no rows found" 😞

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    2 years ago

    AlexisOlson 

    I've been searching for what the heck does the empty parameter in paginated reports actually return ðŸ˜…

    • IcingOnTheCake's avatar
      IcingOnTheCake
      Icon for Helper III rankHelper III
      2 years ago

      Haha 😜 

      but although we know now, I still dont get why do not get results 😕