Top 10 Matrix Cross Selling


#1

Hi Sam,

Recently I saw your excellent video on the Cross Selling Deep Dive, great topic!

I’m trying to rebuild your model with our data and I have a question for you.

In our model we have 757 different products and a part of the report is:

As you see this report contains a lot of data so I want to see, for example, the Top 10 of Comparison Products instead of all.

Your example-file:

181211%20Cross%20selling-2

I’ve brought this to Excel and the Top 10 of your example-file for Products 1 and 2 is:

Is it possible to create those Top 10 Comparison Products in DAX? If so, can you help me with the formula?

Thanks in advance,

Cor


#2

Something just like the below will get you what you need I believe

Purchased Both Products (Top 10) =
VAR ComparisonRanking = RANKX( ALL( 'Comparison Products'[Index] ), [Purchased Both Products],, DESC )

RETURN
IF( ComparisonRanking <= 10, [Purchased Both Products], BLANK() )


#3

Nice solution Sam, as always. Thank you very much!