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
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Power BI Monthly Update - August 2024
Check out the August 2024 Power BI update to learn about new features.
Fabric Community Update - August 2024
Find out what's new and trending in the Fabric Community.
