SALES AMOUNT RESTOCK

[Anonymous]

Hi all,

I have a measurement which measures the sales amount realized by customers who have made more than one order (restock, réassort in french, not sure for the english word). measure below :

Sales restock = 
CALCULATE(
    [sales],
    FILTER(
        VALUES( ‘sales_table’[customer_id] ),
        CALCULATE( CALCULATE(DISTINCTCOUNT( ‘sales_table’[order_id] ),FILTER(ALL(calendar),calendar[date]<=MAX(calendar[date]))) >= 2 -- purchases this year
    )
    )

)

But this measure shows the whole sales amount made by these customers. I would like to have for the same customers, the real sales amount in restock which is --> Sales amount by customer in restock (more than 1 order) minus sales amount of the first order.

I have a classical sales and calendar table.

I hope I am clear.

Thanks a lot for your help.

Regards.

Paul

[Jihwan_Kim]

Hi, @Anonymous 

If the question is still open, and if it is OK with you, could you please share your sample pbix file?

Then I can try to come up with more accurate measures to find a solution.

Thank you very much.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.