Problems with ISONORAFTER

[Anonymous]

Im trying to divide the parcels of my products in line and tried to do something like this

the measure ReceivedValue running total... works fine with DocName that the parcels have the same value(A,C) but when there is a value different in the parcel(B,D) things don't work very well. Can someone help me with this?

This is what i expect 

Thanks

Power Bi File 

[FrankAT · Accepted solution]

Hi @Anonymous ,

you can do it like this (take a look at the attached PBIX file):

Running Total = 
CALCULATE (
    [Sum of ReceivedValue],
    FILTER (
        ALLEXCEPT ( Planilha1, Planilha1[OrderId] ),
        Planilha1[DatePayment] <= MAX ( Planilha1[DatePayment] )
    )
)

Sum of ReceivedValue = SUM(Planilha1[ReceivedValue])

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)