Forum Discussion
Circular dependency error
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.
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.