Reply
smpa01
Super User
Super User
Partially syndicated - Outbound

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 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
1 ACCEPTED SOLUTION

Syndicated - Outbound

IF function only returns a scalar value.

View solution in original post

6 REPLIES 6
jeffrey_wang
Power BI Team
Power BI Team

Syndicated - Outbound

There is no such function in DAX.

Syndicated - Outbound

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

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Syndicated - Outbound

IF function only returns a scalar value.

parry2k
Super User
Super User

Syndicated - Outbound

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k
Super User
Super User

Syndicated - Outbound

@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

 

parry2k_0-1694021313900.png

 

when val is not 1

 

parry2k_1-1694021338874.png

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Syndicated - Outbound

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_0-1694023383798.png

 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)