How to get customer order wrt item/product except first order

[komald]

I have created a measure which gives me first order date of the customer with respect to each item or product

Dax for first order of the customer wrt item/products

FOD_WRT_PRODUCT_CUSTOMER = MINX(

TOPN(1,New_Product_Item,MIN(New_Product_Item[FactSales.Posting Date]),ASC),New_Product_Item[FactSales.Posting Date])

Now , I wan to find out remaining order of the customer w.r.t item/product except first order , im not able to write dax for the same please help me out. Thanks

[v-kkf-msft · Accepted solution]

Hi @komald ,

Please try the measure and show items when the measure is not blank.

Measure = 
VAR FirDate =
    CALCULATE (
        MIN ( New_Product_Item[FactSales.Posting Date] ),
        ALLSELECTED ( New_Product_Item[FactSales.Posting Date] )
    )
RETURN
    COUNTROWS (
        FILTER ( New_Product_Item, New_Product_Item[FactSales.Posting Date] <> FirDate )
    )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tamerj1]

Hi @komald 
You may try 

Sales Quantity =
VAR FirstSalesDate = [FOD_WRT_PRODUCT_CUSTOMER]
RETURN
    CALCULATE (
        SUM ( New_Product_Item[FactSales.Quantity] ),
        New_Product_Item[FactSales.Posting Date] <> FirstSalesDate
    )