Forum Discussion
Running total based on multiple column
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....
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 You are going to need an Index or Date column to allow you to define "before".
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])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 🙂