Conditional table functions in dax

[smpa01]

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 

[jeffrey_wang]

There is no such function in DAX.

[smpa01]

@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?

[jeffrey_wang · Accepted solution]

IF function only returns a scalar value.

[parry2k]

@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.

[parry2k]

@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]

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.