Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

@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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

@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
Not applicable

Thanks Nathan

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.