ALLEXCEPT with a range

[JohannSteyn]

Hi, I'm new here.
I am trying to add a colum that will show the SUM of "amount to distribute" IF
1 - the "juristicentityid" is the same AND
2 - the "id" is equal to or larger than all of the other "id"'s for the same "juristicentityid"

(I think I need to add another filter where I show "???")

Example of what I need:

[amitchandak · Accepted solution]

@JohannSteyn , try a measure like

Sumx(filter(Table, [juristicentityid] = earlier([juristicentityid]) && [id] >= earlier([id])) ,[amount to distribute])