Compare 2 tables and count number of repeating items including zero

[LizziePeters]

 I have 2 tables in power BI, table A and table B.  Table A contains a list of all products to download from a website in an excel file.  Table B contains a list of downloads from that website.  I want to know how many times each product in table A has been downloaded, including no downloads.  

Desired output as follows:

Product	Number of downloads
Knife	12
Spoon	4
Fork	0

Thank you !!!

[Anonymous]

Hi @LizziePeters 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[vanessafvg]

create a lookup table that contain unique list of your products

then join both of your other tables to the the product table on product.

you will then be table to sum which have downloads

for those that dont you can do an
2
downloadscount =
IF ( ISBLANK ( table[downloads] ), 0, SUM ( table[downloads] ) )

drag the product from your lookup table

[ryan_mayu · Accepted solution]

@LizziePeters 

could you please share the sample data?

maybe you can drag two columns to the table and set one to count.