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" 😞