Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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")))))
Solved! Go to Solution.
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
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
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.
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.
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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.