topic Get Measures for new Calculated measure field in App Development

Get Measures for new Calculated measure field

jaina — Sat, 16 Nov 2024 01:39:41 GMT

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 — Mon, 17 Aug 2020 11:47:24 GMT

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

sum(

aggr(

if(

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

)

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

)

jaina — Tue, 18 Aug 2020 00:35:21 GMT

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