ACCUMULATE CALCULATION

[CR7]

I have de following matrix with 2 Orders (A and B) with 2 lines of material per line

HOW TO CREATE THE "Total of Order" COLUMN THAT HAS IN EACH LINE THE TOTAL VALUE OF THE ORDER THAT IS EQUAL TO THE SUM OF THE PARTIAL VALUES OF EACH LINE OF THE ORDER

Order    lines       Value        Total of Order

A                 1            20                  30

A                 2            10                  30

B                 1              5                  20

B                 2             15                 20

[amitchandak · Accepted solution]

@CR7 ,

A new column

Sumx(filter(table, [Order] = earlier([Order])),[Value])

a new measure 

Sumx(filter(allselected(table), [Order] = max([Order])),[Value])

Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

[CR7]

THANK YOU FOR YOUR HELP