DAX match text in multiple columns

Hi, I've been trying to figure out how can I get this report done but I can't find any efficient way to fo it. I have 2 tables:   [Table1] Sales by brand and date: Brand Date Sales Apple...