I have implemented basket analysis in my report. want to calculate sales of that customers?

[Anonymous]

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: 

CrossSell Customer Count = CALCULATE (

DISTINCTCOUNT( SalesFact[CustomerID]),

CALCULATETABLE (

SUMMARIZE (

'SalesFact',

SalesFact[CustomerID]

),

ALL ( ProdFilter ),

USERELATIONSHIP ( SalesFact[ProductKey], ProdFilter2[Product2Name] )

)

)

In the given case the CrossSellLIV should be :

Monthnumber    CrossSell Customer Count    CrossSellSales            Expected CrossSell Sales

M1                            2                                                30                                40

M2                            1                                                20                                30

Model

Please see the expected result for sales by checking data in the Reference table.

Expected result is shown in orange color column

[v-chuncz-msft]

@Anonymous ,

You may take a look at https://www.sqlbi.com/articles/apply-and-logic-to-multiple-selection-in-dax-slicer/.

[Anonymous]

@v-chuncz-msft ,

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.