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.
Exclusive opportunity for Women!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
