Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-23-2023
04:08 PM

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)
)
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-23-2023
04:08 PM

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)
)
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
05-18-2025 08:21 AM | |||
05-05-2025 09:49 PM | |||
06-05-2025 09:14 AM | |||
05-06-2024 05:39 AM | |||
04-10-2025 03:18 AM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
96 | |
91 | |
52 | |
47 | |
44 |