Latest Enterprise DNA Initiatives

Sum Quantity where [item] has a match in item table

I have a measure =
Calculate(SUM(‘Transaction Lines’[Quantity]),
‘Transaction Lines’[Type] = “Sales Order”)

My table shows quantity for the shipping and tax lines and I want to excluded those from the count, yet the “Item” column have various names for the shipping and tax lines. How can I write the measure to only sum the quantities where the “item” column has a matching text in the “Item” table?

Hi @Usates,

Try something like this

Measure =
    SUM( 'Transaction Lines'[Quantity] ),
    'Transaction Lines'[Type] = "Sales Order",
    'Transaction Lines'[ITEM] IN VALUES( 'Item'[ITEM] )

I hope this is helpful.


Thank you!