I need a output of cummulative total of stages with descending order as below
I have created a measure as below
Deals = CALCULATE (
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
If the last stage is not there, need to show as 0. But it showing as total value.
Need a Help!!!
Without detailed information, i can't reproduce your problem on my site or find which leads to the problem.
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