Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Problem with summing in running total

Hi All, I have a problem with summing in running total - values do not add up. I want to calculate the running total for the PCS_Claimed column for the Complaints_reason_PAC category. I tried such measures:

ThirdPcs =
CALCULATE(
    [PcsSum],
    FILTER(
        ALLSELECTED('PACbi QualityComplaints'[Complaints_reason_PAC]),
        ISONORAFTER('PACbi QualityComplaints'[Complaints_reason_PAC], MAX('PACbi QualityComplaints'[Complaints_reason_PAC]), desc)
    )
)
 
SecondPCS =
CALCULATE(
    [PcsSum],
    FILTER(ALLSELECTED('PACbi QualityComplaints'[PCS_Claimed]),'PACbi QualityComplaints'[PCS_Claimed] <= Max('PACbi QualityComplaints'[PCS_Claimed]) )
)
 
**bleep** Pcs = CALCULATE(sum('PACbi QualityComplaints'[PCS_Claimed]),FILTER(ALL('PACbi QualityComplaints'[PCS_Claimed]),'PACbi QualityComplaints'[PCS_Claimed] >= MAX('PACbi QualityComplaints'[PCS_Claimed])),VALUES('PACbi QualityComplaints'[Complaints_reason_PAC]))
Neither of these measures adds value, but displays the same as PCS_Claimed, I have the same in excel but there it works

Do you know where the mistake is?