How to find which customers are in Both Categories ?

[Anonymous]

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

[Anonymous · Accepted 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]

Thanks Nathan