Forum Discussion
Solved
SUM
Sorry to ask this very simple question, but I am struggling to find the solution for a while now... I have a list of claims, each of them having a "unique" customer claim number (say, 1, 2, 3, 4....
- As a column:Total defects col = SUMX(FILTER(parts, parts[part no] = EARLIER(parts[part no])), parts[defective parts])
Hi,
Write this calculated column formula
=CALCULATE(SUM(Data[Defective Parts]),FILTER(Data,Data[Part Number]=EARLIER(Data[Part Number])))
Hope this helps.
