Running total of measure

[Anonymous]

Hi,

I want to find the Running total of a measure, can you please help me with it, below are the details

This is how my current data is

 

 Expected result

Vertical	01-Apr-2018-Altr	Running total
Analytics	16	16
UET	4	20
DE	0	20
ECM	3	23
Mobility	1	24
Sharepoint	3	27
EWT	3	30
Digital	6	36

Thanks,

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

First, please add a group index column in Query Editor like below:

#"Grouped Rows" = Table.Group(#"Changed Type", {"Vertical"}, {{"All", each _, type table}}),
#"Added Index" = Table.AddIndexColumn(#"Grouped Rows", "Index", 1, 1),

Then, create measure for running total.

running total =
SUMX (
    FILTER ( ALL ( Digital ), Digital[Index] <= SELECTEDVALUE ( Digital[Index] ) ),
    [01-Apr-2018-Atr]
)

Best regards,

Yuliana Gu

[Anonymous]

Thanks @v-yulgu-msft that worked for me:)

[Greg_Deckler]

Take a look at my Time Intelligence The Hard Way quick measure here:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

Basically, you need to do a SUMMARIZE and then return the SUMX of all the rows that are less than the current row value that your running total is based on. So you will get the MAX of the date value in a VAR and then SUMMARIZE and then SUMX of the FILTER of your SUMMARIZE table for all dates less than the MAX in your first VAR. Basically like that.

[Anonymous]

Thanks for your Reply @Greg_Deckler. I am able to follow your Idea, but in this case I am not using the Dates to compare and do a summarization. I have to just do a cumulative sum of the data from the measure, I have tried it using Ranking and I am able to get the Cumulative sum, but my Vertical sort order has to be changed and that makes the data wrong.

Kindly let me know if you have any solution to this scenario and if you need any other inputs.