Next SKU Recommendation for the retailer

[pranshu_07]

SKU Recommendation
Table 1 shows the Total sales in India
RANKX dax is used and visual is made(Not in static table).
IF user will select retailer A, table 2 is shown and based on two tables( Table 1 and Table 2) the next recommended SKU for the retailer is SKU B.
IF user will select retailer B, table 3 is shown and based on two tables( Table 1 and Table 3) the next recommended SKU for the retailer is SKU A.
The table will be dynamic visual and changes when the user changes the selected retailer.
I need a DAX or Logic for the same.

[lbendlin]

IF user will select retailer A, table 2 is shown and based on two tables( Table 1 and Table 2) the next recommended SKU for the retailer is SKU B.

Based on what? price?

[pranshu_07]

Based on the total sales of all retailers i.e. Table 1.

For eg. If user choose Retailer A, he already have SKU C,A and E so the next SKU to recommend the retailer based on the Total sales table(i.e. table 1) is SKU B because its the top ranking sku he dosen't have.

thank you!

[pranshu_07]

All the calculation and process have to based on the sales, no other variable.