Adding a condition in distinct union function

[Anonymous]

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 =  DISTINCT(union(FILTER(distinct(' Employee Hours'[Code]),'Employee Hours'[Code]<>""),FILTER(distinct(' Asset Hours'[Code]),'Asset Hours'[Code]<>"")))

Now, I want to add another condition for each table:

Simply, I just want to union the codes of two below tables if in employee table, crew type be MGMT and in Asset table, the crew type be Maint. Off course, empty codes must not be considered.

No idea what to do. your help would be highly appreciated.

[v-jiascu-msft]

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

[Anonymous]

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?

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

It works in my test. Did you make any changes?

Best Regards,

Dale

[Anonymous]

Thank you so much for your time and help 

[Anonymous]

no one has any idea?