Main Category (based on sales) for Second Order

[ErikOmni]

Hi!

So I'm trying to create a column with the main product category in the second order from each individual customers.

I have already created a column for the First Order, since the date of the first order exists in the dataset. See below formula:

Main Category_First Order =

    VAR __Cust = [CustomerID]

    VAR __First = OrderData[Customer.FirstOrder.1]

    VAR __Table = FILTER(OrderData,[CustomerID] = __Cust && [OrderDate] = __First)

    VAR __Max = MAXX(__Table,[Total Sales])

    VAR __Category = MAXX(FILTER(__Table,[Total Sales] = __Max),[Category])

RETURN

    __Category

Then I created an Order Rank to allow me to identify each order

Order Rank =

rankx(filter(OrderData, [CustomerID] = earlier([CustomerID] ) ) , OrderData[OrderDate],,asc,dense)

However, now I tried to partially replicate the first methodology to create a column for the main category in the second order, like this:

Main Category_Second Order =

    VAR __Cust = [CustomerID]

    VAR __Second = OrderData[Order Rank] = 2

    VAR __Table = FILTER(OrderData,[CustomerID] = __Cust && OrderData[Order Rank] = __Second)

    VAR __Max = MAXX(__Table,[Total Sales])

    VAR __Category = MAXX(FILTER(__Table,[Total Sales] = __Max),[Category])

RETURN

    __Category

But that landed me this...

Any ideas how one might solve this?

Thanks!

[amitchandak · Accepted solution]

@ErikOmni , there are two equal sign, that seem problem to me

Main Category_Second Order =
VAR __Cust = [CustomerID]
VAR __Second =  2
VAR __Table = FILTER(OrderData,[CustomerID] = __Cust && OrderData[Order Rank] = __Second)
VAR __Max = MAXX(__Table,[Total Sales])
VAR __Category = MAXX(FILTER(__Table,[Total Sales] = __Max),[Category])
RETURN
__Category