Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
I have been reading about circular dependencies and am a bit confused by all the information since each scenario is different. I'm hoping someone might be able to help me with this.
I have a calculated measure
% Late Assessments = calculate(if(isblank(WeeklyAssessment[Count Late] / DISTINCTCOUNT(WeeklyAssessment[SurveyMasterID])) = TRUE,0,WeeklyAssessment[Count Late] / DISTINCTCOUNT(WeeklyAssessment[SurveyMasterID])))
From here, I'm just trying to create a column that states:
The circular dependency referring to "Max Hits" is a column that has nothing to do with this measure that I can tell.
Max Hits = calculate(Max(WeeklyAssessment[NumberOfTeamLeadHits]), allselected(WeeklyAssessment[WEEK]))
Any thoughts?
Solved! Go to Solution.
Hi @heidibb,
I think 'WeeklyAssessment[Count Late]' is a measure which stored in your table and will try to calculate through your date column, right?
If this is a case, I think the circular dependency is caused by this date column, both two measures are try to calculate through this column and power bi can't confirm which calculation will be process first.
You can also refer to below link to know more about this issue:
Understanding Circular Dependencies in Tabular and PowerPivot.
Regards,
Xiaoxin Sheng
Hi @heidibb,
I think 'WeeklyAssessment[Count Late]' is a measure which stored in your table and will try to calculate through your date column, right?
If this is a case, I think the circular dependency is caused by this date column, both two measures are try to calculate through this column and power bi can't confirm which calculation will be process first.
You can also refer to below link to know more about this issue:
Understanding Circular Dependencies in Tabular and PowerPivot.
Regards,
Xiaoxin Sheng
When you use a CALCULATE statement in a calculated column, it transitions in every other column in the table, including other calculated columns, into the filter context unless you explicitly exclude them using functions like ALLEXCEPT.
So in your case, the measures '% Late Assessments' and 'Max Hits' are trying to transition each other into their respective filter contexts. Since from DAX's perspective it cannot resolve one measure without the other already being computed, it detects a circular dependency and throws an error.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |