Cumulative of (Value^2)

[gggar]

Hello,

I have a question to calculate running sum of a formula.

I have a table

I want to calculate the running sum of (Value^2).

I expect to have for each row:

(7^2) = 49

(7^2) + (1^2) = 50

(7^2) + (1^2) + (2^2) = 54

I tried to do it in DAX

Measure 5 = 
CALCULATE (
    SUM (Master[Value]) * SUM (Master[Value]),
    FILTER (
        ALL ( Master ),
        Master[Date] <= MAX ( Master[Date] )
    )
)

But the result is

Anyone can help me for the correct DAX to get 49, 50, and 54 as the running sum?

Any help will be greatly appreciated! Thank you.

[gggar]

@Fowmy , thanks a lot!

[Fowmy · Accepted solution]

@gggar 

Use the formula this way:

Value Measure = 
var _date =  MAX(Master[Date]) return
CALCULATE(
    SUMX(VALUES(Master), Master[Value] * Master[Value]),
    Master[Date] <=_date 
)