Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hi, I need help with this:
From the table that is included in the attached file, I calculate the following 3 measurements:
1) Total Population = SUM( 'Singapore_Salary_Range'[Population] )
2) Cumulative_population =
CALCULATE(
//expresion
SUM(Singapore_Salary_Range[Population]),
//filtro
FILTER(
//tabla o expresion que retorna una tabla
ALL(Singapore_Salary_Range),
Singapore_Salary_Range[Salary range (from)]<=MAX(Singapore_Salary_Range[Salary range (from)])
)
)
3) Cumulative population (%) =
DIVIDE(
//numerdor
[Cumulative_population],
//denominador
[Total population]
)
Measure number 3 gives the following error: "Circular dependency detected."
How can I perform this calculation without getting an error?
Attached POWER BI file
https://drive.google.com/file/d/13pIdCP_0kDA3N5jwC9IzEht8P4q5EZOa/view?usp=sharing
Thank you
Solved! Go to Solution.
pls try this
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 57 | |
| 40 | |
| 27 | |
| 25 | |
| 23 |
| User | Count |
|---|---|
| 127 | |
| 105 | |
| 55 | |
| 39 | |
| 33 |