Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
---|---|
86 | |
82 | |
68 | |
67 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |