First Order of Specific Product by Consumer ID

[ciken]

I have started building my consumer table with first order placed (pulling from 'Operations: Orders'), but I'd like to add a second column that shows the first time they placed an order using our Auto Refill program (Pulls from 'Operations: Orders Shopping Cart'). I've been able to use 

FirstTimePurchase = CALCULATE(MIN('Operations: Orders'[Order Date]), ALLEXCEPT('Operations: Orders',Customer[CustomerID])) to get the first order ever placed under that User ID, but when I try and create a new column with an additional filter 

FirstASTimePurchase = CALCULATE(MIN('Operations: Orders'[Order Date]), ALLEXCEPT('Operations: Orders',Customer[CustomerID]),FILTER('Operations: Orders Shopping Cart','Operations: Orders Shopping Cart'[Subscription Type (2)]="Auto Refill")) I end up with the first date for any auto refill order all the way down the table. I do not know what I'm doing wrong. Screen shot below...

Thanks

[ciken · Accepted solution]

I was able to finally build the data to be accurate...below was the final solution.

FirstASTimePurchase = CALCULATE(MIN('Operations: Orders'[Order Date]), FILTER(ALL('Operations: Orders Shopping Cart'),'Operations: Orders Shopping Cart'[CustomerID]=EARLIER(Customer[CustomerID])&&'Operations: Orders Shopping Cart'[Subscription Type (2)]="Auto Refill"),FILTER('Operations: Orders','Operations: Orders'[Transaction State]<>"Voided"))

[v-shex-msft]

HI @ciken,

Power bi data model tables do not support setting multiple sort order field.

For your requirement, I'd like to suggest you create a calculated column with ISONORAFTER function to rank based on multiple columns and sort by this new field or do these sorting in query editor side and add an index column to save current sorting effect.

Sorting by multiple columns 

Regards,
Xiaoxin Sheng