cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Krithika Frequent Visitor
Frequent Visitor

Issue with Cummulative sum of category with descending order

Hi,

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

Capture.PNGOutput

 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

Capture.PNGOutput 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

1 REPLY 1
Community Support Team
Community Support Team

Re: Issue with Cummulative sum of category with descending order

Hi @Krithika

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