Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
In my orders table, I have the order_id and a sub-order id created if the customer has sent a Laptop along with his/her Mobile which is our main service. Both orders have the exact pickup date, but different order_ID.
I need to know whether the first order of all our customers has a laptop included. I did order ranking through this DAX formula:
@amitchandak it didn't work.
Maybe I asked the question wrong.
How about how can I filter the orders table where if order rank 1 and order rank 2 have the same pickup date, then sum the laptop contribution?
@Andrew_na_lang ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Is there any blank value, not sure why you are getting rank as 2
@amitchandak here's a sample table.
The goal is to mark all customers with LAPTOP in their first order, be it main order or sub-order id.
@Andrew_na_lang , Try like
RANKX ( Filter(Orders, Orders[customer_id] = earlier(Orders[customer_id]) && [Laptop_contribution] =0 && not(isblank([Laptop_contribution] )) ), orders[time_pickup_id].[Date],, ASC )
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 10 | |
| 10 | |
| 8 | |
| 6 | |
| 6 |
| User | Count |
|---|---|
| 24 | |
| 19 | |
| 19 | |
| 15 | |
| 9 |