Combining Data from two different columns stored in a variable

[Anonymous]

Consider the following two variables:

VAR A = MembershipHistory[Membership]

VAR B = Memberships[Membership]

Table MembershipHistory and Memberships have some common values in their column Membership and I want their distinct count. How can I join data from both variables so that I could apply distinct count on it. Please help.

[Greg_Deckler · Accepted solution]

@Anonymous Try:

RETURN
  COUNTROWS(DISTINCT(UNION(A, B)))

[Anonymous]

Hi Greg, that works for this problem, but I also have another measure where the variable A is storing 3 columns and variable B is storing 2 columns. The union will not work there as the no of columns are not same. Can you please help with that too?

Thanks in advance

[v-easonf-msft]

Hi, @Anonymous 

Please check if formula below could help:

COUNTROWS (
    DISTINCT ( UNION ( VALUES ( A[Column1] ), VALUES ( B[Column1] ) ) )
)

Best Regards,
Community Support Team _ Eason