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.
Hi All Gurus,
This site really helping me on my 1st steps of DAX.
My question is, is there any way to find which customers are in both Groups and the total?
Example , A Group : UserId: 1, 3 , 5 , 6
B Group : UserID: 3 , 5, 8
BothGroup : 3, 5
I need to find out how to achieve Result BothGroup which is 3, 5 because these customers are in Both Group.
Thanks in advance
Solved! Go to Solution.
@Anonymous -
Store each group in a variable and then try the NATURALINNERJOIN orINTERSECT functions. Something like:
var a = <customer list 1> var b = <customer list 2> var c = NATURALINNERJOIN(a,b)
Cheers!
Nathan
@Anonymous -
Store each group in a variable and then try the NATURALINNERJOIN orINTERSECT functions. Something like:
var a = <customer list 1> var b = <customer list 2> var c = NATURALINNERJOIN(a,b)
Cheers!
Nathan
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |