Forum Discussion
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...), a date, and is about a specific part number. Plus the number of defective parts.
I'd like to add a column (or measure) in my table (the green area), showing the total defective part for each part number.
For a reason I won't elaborate here, I want to get this info. within the same table (otherwise a new visual would make it !).
Thanks for your kind help !
Albin
- 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.
3 Replies
- As a column:Total defects col = SUMX(FILTER(parts, parts[part no] = EARLIER(parts[part no])), parts[defective parts])
The EARLIER worked like a charm, in both formulae SUMX(FILTER and CALCULATE(SUM ; FILTER
Many thanks !
Hi,
Write this calculated column formula
=CALCULATE(SUM(Data[Defective Parts]),FILTER(Data,Data[Part Number]=EARLIER(Data[Part Number])))
Hope this helps.
