Circular dependency error

[catrin_reach]

Hi all,

I am relatively new to PowerBI so am struggling with an error on circular dependencies. I've read a lot of post forum posts on this, watched youtube videos etc and still don't understand how to solve it. I've tried! 

The end goal is to calculate the number of children who have attendance <=90%, <50% and =0%. I've created the <=90%  with the 'Meets PA threshold' as a column in the table, and then PA# and PA % as measures. When I create the <50% column I get the circular dependency error. 

This is my current formula for Meets PA threshold:

Meets PA threshold =

IF (

    AND (

        [Stat sch age %] <= 0.90,

        'Attendance all children'[Possible attendance sessions] > 0

    ),

    "Yes",

    "No"

)

Can anybody help please? Thanks in advance. 

[v-zhangti]

Hi, @catrin_reach 

What is your formula? Which step went wrong?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[catrin_reach]

It goes wrong when you create more than one column and when I use that DAX as a measure I get an error that says a single value for column 'Possible attendance sessions' can't be determined. 

Here is the pbix file 

[Syndicate_Admin]

Maybe the formula is fine and really is more related at the time it calculates is filtering a column that you are calling, to perform the calculation the calculation calls another column that is required but this by the construction of the table or previous formulas is filtered before it reaches the calculation you request, creating a circular relationship, try to make the measurement and not creating columns or changing the relationships of tables that you have that also affect the filters, you can also change the order in which you create the columns.

[catrin_reach]

There is only one table so it is not a relationship issue. 

My knowledge of PowerBI isn't good enough to create the same as a measure unfortunately, so any help with that gratefully received.