Forum Discussion

jPinhao's avatar
jPinhao
Icon for Advocate II rankAdvocate II
9 years ago
Solved

DAX - Error on trying to return tables from an IF() statement

I'm trying to build a DAX expression that will join a table with 1 of 2 others, depending on whether one of these other tables is empty: VAR OwnedIDs = IF(ISEMPTY(FilteredOwnedFeatures), ...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    jPinhao

     

    In DAX, you can't specify a dynamic filter context in CALCULATE(). And what IF statement returns should be value, if the value_if_ture is a column, it returns the value that corresponds to the current row. You can't make it returns a table context which contains multipe columns as the error message mentioned.

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

jPinhao

 

In DAX, you can't specify a dynamic filter context in CALCULATE(). And what IF statement returns should be value, if the value_if_ture is a column, it returns the value that corresponds to the current row. You can't make it returns a table context which contains multipe columns as the error message mentioned.

 

Regards,

jPinhao's avatar
jPinhao
Icon for Advocate II rankAdvocate II
9 years ago

Thanks for the insight Simon. I found a way around, changing one of my tables to ensure the query wouldn't end up empty and always get a meaningful result back - this has the side effect of having data in there which we don't care about, but it can be filtered out :)