Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |