Forum Discussion
Adding a condition in distinct union function
Hi everybody, I am new in Power Bi & appreciate if anyone help me here: I want to union the codes in 3 seperate tables and set the below formula which works correctly. Maintenance WO = DISTIN...
Hi Anonymous,
It works in my test. Did you make any changes?
Best Regards,
Dale
Hi Anonymous,
You almost got there. Try the formula below, please.
Table =
DISTINCT (
UNION (
CALCULATETABLE (
VALUES ( Employee[Code] ),
FILTER (
Employee,
ISBLANK ( Employee[Code] ) = FALSE ()
&& Employee[Crew] = "MGMT"
)
),
CALCULATETABLE (
VALUES ( Asset[Code] ),
FILTER ( Asset, ISBLANK ( Asset[Code] ) = FALSE () && Asset[Crew] = "Maint" )
)
)
)
Best Regards,
Dale
Hi v-jiascu-msft,
Thanks for your time.
I tried your formula, but I got an error message that "Too few arguments were passed to the Union Function.The minimum argument count for the function is 2"
Any idea?
Hi Anonymous,
It works in my test. Did you make any changes?
Best Regards,
Dale
Thank you so much for your time and help :smileyvery-happy: