Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Could you please help to get DAX formula to get Unique count between two tables.
PBIX: PBIX Sample
Formula:
Regards,
Chandrashekar B
Solved! Go to Solution.
@Chandrashekar
You can use
Count Available in Both =
COUNTROWS (
FILTER (
INTERSECT (
VALUES ( Table1[Number] ),
VALUES ( Table2[Number2] )
),
NOT ISBLANK ( [Number] )
)
)
Hello,
Could you please help to get DAX formula to get Unique count between two tables.
PBIX: PBIX Sample
Formula:
Regards,
Chandrashekar B
Hi Chandra,
What exactly are you trying to count?
Hello,
am trying to count Number ticket(Table1) present in Table2.
Kindly note Table2 may have Number which is not present in Table1.
Regards,
Chandrashekar B
@Chandrashekar
You can use
Count Available in Both =
COUNTROWS (
FILTER (
INTERSECT (
VALUES ( Table1[Number] ),
VALUES ( Table2[Number2] )
),
NOT ISBLANK ( [Number] )
)
)
Hello,
Thank you. It is working fine.
Regards,
Chandrashekar B
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |