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 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.

Need Help

3 Replies

  • 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