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...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
2 years ago

IcingOnTheCake 
Try to replace NOT ( ISBLANK ( TRIM ( @P_PL2 ) ) ) with TRIM ( @P_PL2 ) <> ""

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

no. unfortunatley that did not help

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

    IcingOnTheCake 
    When nothing is selected what does your parameter return?

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

      As null is not allowed for this slicer, it should be BLANK.
      In Report Builder, what does a Slicer return, if nothing is selected?
      Normally it's blank.