Forum Discussion
Issue with allocating quantity based on match in another column
Hello Community! In a previous post I had the following problem: I have a table containing a list of article codes that represent tyres or wheelsets. All have a forecasted quantity. The whee...
Anonymous , Try a new measure for total quantity and check
sum(Table[Quantity]) + calculate(sum(Table[Quantity]), filter(allselected(Table), Table[Contains Tyre] = max(Table[Article Code])))
or
sum(Table[Quantity]) + calculate(sum(Table[Quantity]), filter(allselected(Table), Table[Contains Tyre] = max(Table[Article Code])))+0
amitchandak
Super User
Super UserAnonymous , Try a new measure for total quantity and check
sum(Table[Quantity]) + calculate(sum(Table[Quantity]), filter(allselected(Table), Table[Contains Tyre] = max(Table[Article Code])))
or
sum(Table[Quantity]) + calculate(sum(Table[Quantity]), filter(allselected(Table), Table[Contains Tyre] = max(Table[Article Code])))+0