Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@ayushbot Try:
RETURN
COUNTROWS(DISTINCT(UNION(A, B)))
@ayushbot Try:
RETURN
COUNTROWS(DISTINCT(UNION(A, B)))
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
Hi, @ayushbot
Please check if formula below could help:
COUNTROWS (
DISTINCT ( UNION ( VALUES ( A[Column1] ), VALUES ( B[Column1] ) ) )
)
Best Regards,
Community Support Team _ Eason