Forum Discussion

Ira_Ira's avatar
Ira_Ira
Frequent Visitor
3 years ago
Solved

not working as expected

hi all                                                        
Need Help
Show and Tell
  • bolfri's avatar
    bolfri
    3 years ago
    Count oppo =
    var current_stage_id = MAX(dim_stage[stage_id])
    return
    SUMX(
    SUMMARIZE(
    ALL(fact_opp),
    fact_opp[Opp ID],
    "max stage",MAX(dim_stage[stage_id])
    ),
    IF([max stage] >= current_stage_id,1)
    )
     

     

bolfri's avatar
bolfri
Solution Sage
3 years ago
Count oppo =
var current_stage_id = MAX(dim_stage[stage_id])
return
SUMX(
SUMMARIZE(
ALL(fact_opp),
fact_opp[Opp ID],
"max stage",MAX(dim_stage[stage_id])
),
IF([max stage] >= current_stage_id,1)
)