Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Combining Data from two different columns stored in a variable

Consider the following two variables: VAR A = MembershipHistory[Membership] VAR B = Memberships[Membership] Table MembershipHistory and Memberships have some common values in their column Memb...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous Try:

    RETURN
  COUNTROWS(DISTINCT(UNION(A, B)))
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous Try:

RETURN
  COUNTROWS(DISTINCT(UNION(A, B)))
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    v-easonf-msft
    Community Support
    3 years ago

    Hi, Anonymous 

    Please check if formula below could help:

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

    Best Regards,
    Community Support Team _ Eason