Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Union Function Error message

Hi ,

I get n error message that few argument were passed to he UNION function, the minimum argument count for the function is 2.

below is my formula:

Code= DISTINCT(

   filter(

       union(

          CALCULATETABLE(

             values('Employee Hours'[ Code]),filter(' Employee Hours',ISBLANK(' Employee Hours'[ Code]=false()&&' Employee Hours'[Crew]="MGMT")), CALCULATETABLE(values (' Asset Hours'[ Code]),filter(' Asset Hours',ISBLANK(' Asset Hours'[ Code] =false()&&' Asset Hours'[Crew]="Maint")))))

1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

 

Please try this:

 

CALCULATETABLE (
    VALUES ( 'Employee Hours'[ Code] ),
    FILTER (
        ' Employee Hours',
        ISBLANK ( ' Employee Hours'[ Code] ) = FALSE ()
            && ' Employee Hours'[Crew] = "MGMT"
    )
)

 

Best regards,

Yuliana Gu

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

 

Please try this:

 

CALCULATETABLE (
    VALUES ( 'Employee Hours'[ Code] ),
    FILTER (
        ' Employee Hours',
        ISBLANK ( ' Employee Hours'[ Code] ) = FALSE ()
            && ' Employee Hours'[Crew] = "MGMT"
    )
)

 

Best regards,

Yuliana Gu

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Seward12533
Solution Sage
Solution Sage

My guess is that one of the tables is evaluating to a null or blank table.  Try writing test measures to test each of the CalculateTable functions independantly and inspect the results. 

Anonymous
Not applicable

I tried the blow:

test= CALCULATETABLE(

             values('Employee Hours'[ Code]),filter(' Employee Hours',ISBLANK(' Employee Hours'[ Code]=false()&&' Employee Hours'[Crew]="MGMT"))

 

and I got the error message that  DAX comparison operations do not support comparing values of type Text with values of type True/False. Consider using the VALUE or FORMAT function to convert one of the values.

Try NOT(ISBLANK()) see if that helps.
Anonymous
Not applicable

I tried the blow:

CALCULATETABLE(

             values('Employee Hours'[ Code]),filter(' Employee Hours',ISBLANK(' Employee Hours'[ Code]=false()&&' Employee Hours'[Crew]="MGMT"))

 

and I got the error message of DAX comparison operations do not support comparing values of type Text with values of type True/False. Consider using the VALUE or FORMAT function to convert one of the values.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.