Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
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?
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!
All the calculation and process have to based on the sales, no other variable.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
87 | |
71 | |
63 | |
60 |