1 ACCEPTED SOLUTION
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)
)
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)
)
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)
)
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)
)
Helpful resources
Power BI September 2023 Update
Take a look at the September 2023 Power BI update to learn more.
