Running total based on multiple column

[Anonymous]

Hi Team,

Please help me on Running total calculation based on multiple columns as a slicers.

Please find the below data for your referance.

If I select HEAD as A, need output below.

If I select HEAD as A and YEAR as 2023, need output below.

If I select HEAD as A, Category as C1 and Org as HR then Expecting below out.

Thank you,

@amitchandak , @daXtreme @Greg_Deckler @Fowmy @tamerj1 @Jihwan_Kim 

[Greg_Deckler]

@Anonymous You are going to need an Index or Date column to allow you to define "before".

[Anonymous]

Hi @Greg_Deckler 

I am fine with Value column as INDEX,

Thank you.

[Greg_Deckler · Accepted solution]

@Anonymous So you will never had a Value that is less than a "previous" row? If that is the case then you could do this:

Measure = 
  VAR __Value = MAX('Table'[Value])
  VAR __Table = FILTER(ALLSELECTED('Table'),[Value] <= __Value)
RETURN
  SUMX(__Table,[Value])

[Anonymous]

Thank you so much @Greg_Deckler  for your support.

Logic is woking fine but, if previous row value currerent row value same then it is getting wrong running total number.

There is chanse previous row value currerent row value same

Please help me on this 🙂

[Greg_Deckler]

@Anonymous

And, hence, why you need an Index or Date column. No way to solve it if values can be equal or a subsequent value is less than the current value. Just add an Index column in Power Query. Otherwise, you are stuck with a DAX index:

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Mythical-DAX-Index/m-p/1093214#M528

[Anonymous]

Thank you, I will create INDEX column. 🙂