Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have implemented basket analysis and getting the required cross-sell for the products. Now I want to calculate the sales amount for the products.
Can someone please help me out to find the sales measure. See the screenshot of the model that I have used.
I have created the cross sell measure for calculating the count of customers as below:
In the given case the CrossSellLIV should be :
Monthnumber CrossSell Customer Count CrossSellSales Expected CrossSell Sales
M1 2 30 40
M2 1 20 30
Please see the expected result for sales by checking data in the Reference table.
@Anonymous ,
You may take a look at https://www.sqlbi.com/articles/apply-and-logic-to-multiple-selection-in-dax-slicer/.
The link provided by you works if I have only one slicer in the report. But in my case, I am having two slicers for Product 1 and Product 2. So this doesn't work in my case.
Thank You.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |