issue with circular dependency

[Anonymous]

hi all,

When I tried to create some calculated kpi I receive a circular dependency error, and I have no clue how can I fix it. Can you advise me?

currently I have 3 calculated measure: revenue,cost,opex. after that I create a column for my first kpi: thats have the following formula: measure revenue - measure cost simple and it works perfectly.

next I would like to create an other formula: measure revenue-measure cost-measure opex. every time I received the circular error. I also try to create this kpi  using the results for the first kpi and after - opex. however I still receive the error. is anybody has an idea how can I create this 2 kpi using the 3 "values" I have? (revenue,cost,opex)

thank you

[v-yuta-msft · Accepted solution]

@Anonymous ,

There must be some circle in your table relationship or circlie reference in some DAX statements. Please remove the useless relationship or DAX statement. If this issue still persists, please share some sample data and DAX statement.

Community Support Team _ Jimmy Tao

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