DAX formula cumulative running total

[Anonymous]

Hi,

I'm trying to create a new column with the cumulative running total on the Count Case ID. I tried already a lot of things but always with incorrect results. 

Can anyone help me with this?

Thanks!

[amitchandak]

@Anonymous , CountCaseID is column you can have a new column

sumx(filter(Table,[VariantID] =earlier([VariantID])),[CountCaseID])

if it is measure you can have only measure

sumx(filter(allselected(Table),[VariantID] =max([VariantID])),[CountCaseID])

[AlB]

Hi@Anonymous

I'm assuming what you show are the columns of your table placed in a visual (not aggregated) If so, you can create a calculated column in your table:

New column =
CALCULATE (
    SUM ( Table1[CountCaseID] ),
    ALL ( Table1 ),
    Table1[VariantID] <= EARLIER ( Table1[VariantID] )
)

Otherwise, you'll have to detail what it is you are showing (how the second column is built) and show a sample of the relevant tables in your model to get an accurate answer.

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous · Accepted solution]

Hi,

I actually just solved the problem and found where I made the mistake (table was not ranked or sorted. I created a new table with all Variant IDs and counted all Case IDs which follows a certain Variant. Next I created a RANKX to rank the table based on the count. Then I could easily create a quick measure with the running total. 

Thanks for your quick response!

Cheers