How to count using 3 concatenate columns

Question

Hello Guys,&nbsp;I woulld like to ask for help on how to get the count/sum from one table to another table using 3 differen columns.&nbsp;First Table&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Second TableCategory&nbsp; &nbsp;Brand&nbsp; &nbsp;Purchased Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Category&nbsp; &nbsp; &nbsp;Brand&nbsp; &nbsp; &nbsp;DateNike&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Shoes&nbsp; &nbsp;7/31/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Puma&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Shoes&nbsp; &nbsp; &nbsp;8/1/2019Puma&nbsp; &nbsp; &nbsp; &nbsp; Shoes&nbsp; &nbsp;8/1/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Nike&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Shoes&nbsp; &nbsp; &nbsp;7/31/2019Adidas&nbsp; &nbsp; &nbsp; Shirt&nbsp; &nbsp; &nbsp; 8/1/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Puma&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Shoes&nbsp; &nbsp; &nbsp;8/1/2019Nike&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Shirt&nbsp; &nbsp; &nbsp; 8/2/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Nike&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Shirt&nbsp; &nbsp; &nbsp; &nbsp; 8/2/2019&nbsp;count should be:2 Puma shoes 8/1/20191 NIke&nbsp; shoes 7/31/2011 Nike shirt 8/2/2019&nbsp;I did concatenate the 3 columns and buid in relationship but it gave me null values.&nbsp;Any help will be appreciated&nbsp;Thanks Guys&nbsp;

dax · Accepted Answer

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

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

&nbsp;Then create measure like below
Measure = COUNT(Table2[categoty])

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.

Forum Discussion

How to count using 3 concatenate columns

1 Reply

Related content

Concatenate 3 columns

Total Count in Column

create custom column concatenated

Power query - concatenate text columns

Counting nulls