Get Measures for new Calculated measure field

[jaina]

Hi, 

Can anyone help? I have a measure field named Delivered Quantity where

Delivered Quantity = sum(aggr(sum(DISTINCT [Delivery Qty]), [Sales Order],[Sales Order Item No.]))

and field of Order Qty.

Now, i need to have another measure field that will match if Delivered Quantity = Order Qty.

How can I do that? 

[Kushal_Chawda · Accepted solution]

may be below. Assuming sum([Order Qty]) is your measure. 

sum(

aggr(

if(

sum(DISTINCT [Delivery Qty])=sum([Order Quantity]),

<here write what you want to do if condition matched>

)

,

[Sales Order],[Sales Order Item No.])

)

[jaina]

Thank you! It worked. I also tried to add as variable.