Total of a running total in a card

[Anonymous]

Hi, calculated running_ total which I got the correct result. HOwver the custmer wants to see in a card the total sum of each row running total:

So I have the following results 

 Running_Total =

CALCULATE(SUM('PP[Revenue]), FILTER(ALLSELECTED('PP'),'PP'[Rev Month]<=MAX('PP'[Rev Month])))

So intead of havinf a card with the $56 M I need to sum each month running total. I would expetc a result like $254.5 M

How can I achieve the?

[AllisonKennedy · Accepted solution]

@Anonymous  I don't understand why you would want that or what the meaning it provides??? 

But you can use SUMX:

Running Total Inflated = 

SUMX(VALUES(DimDate[MonthYear]), [Running_TotalMeasure])

Hope that helps!

[Anonymous]

Thanks so much, it worked!

[AllisonKennedy]

Awesome! Glad to hear. 😀