Forum Discussion

smpa01's avatar
smpa01
Community Champion
2 years ago
Solved

Conditional table functions in dax

Is it possible to write table functions that are conditional.

Pseudocode

if val=1 return table1 else union(table1,table2)

 

I have a use case where I am querying tables based on a condition and I need the code return correct table tied to the condition.

 

PFA the sample pbix

AlexisOlson jeffrey_wang 

Need Help

6 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    smpa01 there is a trick to it and here it is :

     

     

    Table = 
var val = 1
VAR table1 = ADDCOLUMNS ( t1, "@Filter", val )
VAR table2 = ADDCOLUMNS ( t2, "@Filter", IF ( val = 1, 0, val ) )
RETURN FILTER ( UNION ( table1, table2 ), [@Filter] = val )

     

     

    when val = 1

     

     

    when val is not 1

     

     

     

    • smpa01's avatar
      smpa01
      Community Champion
      2 years ago

      Thanks for this but I was hoping for something like this somehow in DAX. The condition checking is rather large and susequent action is also rather complex.

       

       

    • smpa01's avatar
      smpa01
      Community Champion
      2 years ago

      jeffrey_wang  is there any way to perform any DAX table function in the 2nd or 3rd parameter of IF or it is only programmed to return nothing but scalar?

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    smpa01 end of the day you have to union all the tables and then filter, and build that logic in the filter column. I don't see any other way to do this using DAX.