Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need a output of cummulative total of stages with descending order as below
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
If the last stage is not there, need to show as 0. But it showing as total value.
Need a Help!!!
Thanks,
Krithika
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |