Issue with Cummulative sum of category with descending order

[Anonymous]

Hi,

  I need a output of cummulative total of stages with descending order as below

Output

 I have created a measure as below

Deals = CALCULATE (
[Deal Count],
FILTER(ALLEXCEPT( changestagetatescalation',businessdevelopment'[created],businessdevelopment'[Status Master] ), ('gplbdqty changestagetatescalation'[gpl_bd_stagemaster_id]) >= MAX( changestagetatescalation'[gpl_bd_stagemaster_id] ) )
)

But I am getting an output as

Output for Using the above dax

If the last stage is not there, need to show as 0. But it showing as total value. 

Need a Help!!!

Thanks,

Krithika

[v-juanli-msft]

Hi @Anonymous

Without detailed information, i can't reproduce your problem on my site or find which leads to the problem.

My question:

how the [Deal Count] calculate?

"If the last stage is not there, need to show as 0. But it showing as total value. "

"There" refers to a table? 

where is column [Stage] from? 

How are tables related?

It is prefered to see screenshots or sample data.

As a temporary way, you could create a measure

Measure=IF([Stages]=7,0,[Deals])

Best Regards

Maggie