topic Running Total of a Measure based on Another sorted measure in DAX Commands and Tips

Running Total of a Measure based on Another sorted measure

johnnychallita — Fri, 07 May 2021 11:28:12 GMT

Hello,

I am having trouble creating a new measure (Cumulative share) of running total for Measure 2 (Share %) based on lowest to highest Measure 1 (INDEX).

can someone please help?

Thank you so much

	Measure 1	Measure 2	Running total needed
Item	Index (SORTED)	Share	Cumulative share
A	79	3%	3%
B	84	4%	7%
C	90	23%	30%
D	100	45%	75%
E	130	20%	95%
F	150	3%	98%
G	200	2%	100%

Re: Running Total of a Measure based on Another sorted measure

amitchandak — Fri, 07 May 2021 11:58:10 GMT

johnnychallita , check if this measure can work( I have not tested this)

measure =
var _tab = summzarize(Table,Table[Item], "_1", [measure1], "_2",[Meausre2])
return
sumx(filter(_tab, [_1] <= Maxx(_tab,[_1])),[_2])

Re: Running Total of a Measure based on Another sorted measure

Jihwan_Kim — Fri, 07 May 2021 11:58:54 GMT

Hi, johnnychallita

Please check the below picture and the sample pbix file's link down below.

All measures are in the sample pbix file, and all steps are numbered in front of each measure.

https://www.dropbox.com/s/n73y6w2telmul02/johnnychallita.pbix?dl=0

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

Re: Running Total of a Measure based on Another sorted measure

johnnychallita — Sun, 09 May 2021 21:19:10 GMT

Dear amitchandak ,

Thank you so much for getting back to me. Please note that your solution didn't work out as I still receive [_2] values as a result instead of a rolling sum. is there any other solution?
Thank you!

Re: Running Total of a Measure based on Another sorted measure

johnnychallita — Sun, 09 May 2021 21:21:34 GMT

Hi Jihwan_Kim ,
Thank you for your reply.
please note that I wasn't able to use your solution since the index and the share columns are both measures. I can't create a new table as it has to be dynamic inside the Cumulative Measure.