cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RizzLearn Frequent Visitor
Frequent Visitor

How to find which customers are in Both Categories ?

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
natelpeterson Senior Member
Senior Member

Re: How to find which customers are in Both Categories ?

@RizzLearn -

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

2 REPLIES 2
natelpeterson Senior Member
Senior Member

Re: How to find which customers are in Both Categories ?

@RizzLearn -

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

RizzLearn Frequent Visitor
Frequent Visitor

Re: How to find which customers are in Both Categories ?

Thanks Nathan