SUM on Order Level with Relation within Table

[joshua1990]

Hello everyone!

I have a transactional table that contains the order ID within 2 columns:

Article	Order1	Key	Order2	Quantity
AAAA	100	L1	2001	50
AAAA	101	L1	2200	70
AAAA	105	L2	100	100
AAAA	106	L2	101	100

The L1 key defines the last tracked quantity.

The L2 key defines the first tracked quantity.

Now I need to compare these two numbers to get the yield per order level.

But how?

In the example above for order 100, I would compare L1 = 50 with L2 = 100.

How would you build this relationship between a DAX measure?

[vivran22]

Hello @joshua1990 ,

How do you mean to compare? What is the logic behing grouping? Is it just:

SUM of Order Qty of L1 / Sum of Order Qty of L2?

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter