- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Next SKU Recommendation for the retailer
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
All the calculation and process have to based on the sales, no other variable.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-18-2025 01:52 AM | |||
05-21-2024 04:14 AM | |||
02-06-2025 08:39 AM | |||
02-17-2025 08:25 AM | |||
03-02-2022 07:33 AM |
User | Count |
---|---|
136 | |
107 | |
88 | |
58 | |
46 |