Dynamic combined customer and product 8020 analysis
Hi, Im wanting to create a dynamic measure to analyse which "A" customers bought which "A" products and so on. Must be dynamic, to use the page filters I have. Analysis to spit out: 1) sum of sales for A customer purchasing A product, also AB, BA, BB, etc 2) number of customer (and products) in AA, AB, etc 3) which customers / products in AA, AB etc Data set is transaction order history, so includes customer name / code, product name / code and sale date. Can someone please help as my DAX is not at this level, assume it needs to be done in virtual tables then bringing together?