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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello community members
I am getting cirular dependecies error while creating the below measure, as it is using the other measure for calculation
Remaining COVID-19 Backlog from DSRTF and System Impact = if(wait_list_data[diff]>[previous backlog],[previous backlog],wait_list_data[diff])
Is there any system impact? = if(([Remaining COvid-19 backlog from DSRTF impact]-[Remaining COVID-19 Backlog from DSRTF and System Impact])>0, "yes","No")
If yes, what is the system impact? = if([Is there any system impact?] = "Yes", ([Remaining COvid-19 backlog from DSRTF impact]-[Remaining COVID-19 Backlog from DSRTF and System Impact]),0 )
Current COVID-19 Backog = if((SELECTEDVALUE('Service Line'[Target Backlog ]) - [DSRTF impact]- [If yes, what is the system impact?])<0,0,((SELECTEDVALUE('Service Line'[Target Backlog ]))))
It would be immensely helpful if someone can suggest work around to resolve circular dependency error
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 103 | |
| 80 | |
| 63 | |
| 50 | |
| 45 |