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
ishzoulify
Regular Visitor

How to count using 3 concatenate columns

Hello Guys,

 

I woulld like to ask for help on how to get the count/sum from one table to another table using 3 differen columns.

 

First Table                                                             Second Table

Category   Brand   Purchased Date                       Category     Brand     Date

Nike          Shoes   7/31/2019                                Puma          Shoes     8/1/2019

Puma        Shoes   8/1/2019                                  Nike            Shoes     7/31/2019

Adidas      Shirt      8/1/2019                                 Puma           Shoes     8/1/2019

Nike          Shirt      8/2/2019                                 Nike            Shirt        8/2/2019

 

count should be:

2 Puma shoes 8/1/2019

1 NIke  shoes 7/31/201

1 Nike shirt 8/2/2019

 

I did concatenate the 3 columns and buid in relationship but it gave me null values.

 

Any help will be appreciated

 

Thanks Guys

 

1 ACCEPTED SOLUTION
dax
Community Support
Community Support

Hi ishzoulify,

If you want tto get below result , you could follow below steps:

257.PNG

You could create relatinship between table 1 and table 2 based on category(many to many)

258.PNG

 Then create measure like below

Measure = COUNT(Table2[categoty])

259.PNG

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
dax
Community Support
Community Support

Hi ishzoulify,

If you want tto get below result , you could follow below steps:

257.PNG

You could create relatinship between table 1 and table 2 based on category(many to many)

258.PNG

 Then create measure like below

Measure = COUNT(Table2[categoty])

259.PNG

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.