Creating a Master Measure - two filters

jerryr125 — Fri, 07 Aug 2020 09:46:58 GMT

Hi I am trying to do the following :

* I Only sum the quantity in which the Inventory ID = strt and the Inventory part number = 12345

Sum(${<[inventoryid]={'strt'},[partnumber]={'12345'}>} (Quantity))

Does not seem to work - any thoughts ?

Re: Creating a Master Measure - two filters

iswarya — Fri, 07 Aug 2020 10:02:17 GMT

Hi,

It's because the identifier in the set is placed wrong.

Sum({$<[inventoryid]={'strt'},[partnumber]={'12345'}>} (Quantity))