Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have two columns, each from a different table that are linked. I want to find the count of how many distinct and similar values are between the columns.
For example if one table had a column with values: [chicken, fish, rice, tree, car] and the other table's column had the values [fish, boat, rice, rice, ears, mouse], I would want the count to be 2 because rice and fish show up in both columns.
Edit: I was thinking something along the lines of a distinctcount and an innerjoin. I can't get it to work
Solved! Go to Solution.
Hi @goalie_ ,
You can try a measure
// Given: T1 and T2 that are somehow linked
// meaning a filter can be applied to both
// tables at the same time. We're interested
// in T1[col] and T2[col].
[# Same Values] =
COUNTROWS(
INTERSECT(
VALUES( T1[col] ),
VALUES( T2[col] )
)
)
Best
D
Hi @goalie_ ,
You can also have a look at this article
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @goalie_ ,
You can try a measure
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
13 | |
12 | |
11 | |
9 |
User | Count |
---|---|
65 | |
20 | |
20 | |
17 | |
11 |