Running Total based on sorted column

[CMajka8]

Hello - 

I am looking for a running total DAX formula, however, most of the examples I see use a date column in the fromula. I do not have a date column. The dataset is sorted DESC by Premium. then I want to show a running total of the premium column. So let's say I have the following columns:

Acct, Acct Name, Premium

How do I create a Running Total Premium calc?

Thanks!

[Whitewater100 · Accepted solution]

HI:

 I'll take a guess as not too much has been shared about data model or this is a single table. I hope this helps!

You can start off with a measure that will be referenced by this calc col.

Total Premium = SUM(Table[Premium])

then add this as calculated column in your table.

Premium Amt = [Total Premium]

Cumulated Premium =

CALCULATE(

    [Total Premium],

    ALL( TableName ),

    TableName[Premium Amt] >= EARLIER( TableName[Premium Amt]))

[CMajka8]

Yes, this works - thank you!