Running total from max to min

[parslei]

Hi, I'm posting this in vein hope.

I have a count of population by Practice and I want to create a running total from the practice with the highest population, to the second highest and third etc etc... However, when I try and use the quick measure to build something it only allows me to build on the practice name so it builds a running total in alphabetical order of practice names. I'm at a loss what to do. Any help would be much appreciated 

LD Population running total =

CALCULATE(

    [LD Population],

    FILTER(

        ALLSELECTED(LD[Practice name]),

        ISONORAFTER(LD[Practice name], MAX(LD[Practice name]), DESC)

    )

[parslei]

@Jihwan_Kim thank you so so much this was exactly what I wanted and works as I wanted!!! Brilliant 

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

LD Population running total : =
VAR currentpopulation = [LD Population measure :]
RETURN
CALCULATE (
[LD Population measure :],
FILTER (
ALL ( LD[Practice name] ),
[LD Population measure :] >= currentpopulation
)
)