Forum Discussion

utsavlexmark's avatar
utsavlexmark
Helper III
7 years ago

Issues with Circular Dependency

Let me first explain fields of my dash board with the image.     “partnumber” - Partnumber of the product “mktname” - is the name of the product “CW” – is a calculated metrics and it show...
Need Help
Tips and Tricks
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi utsavlexmark ,

 

In your case, Power BI does not allow to have two calculated columns that contain measures that are also based on that table.  In order to understand why, you'd need a better understanding of what's going on under the hood.

In order to get around it, you should try turning these into measures

 

BTW, you can refer to the third - party blog to know more about Circular Dependency.

https://www.sqlbi.com/articles/understanding-circular-dependencies/

  • utsavlexmark's avatar
    utsavlexmark
    Helper III
    7 years ago

    Sorry to the coumunity; I kept this thread open - as I was trying to solve this issue. 

    As you all know that it is not possible to over come the circular dependency; I have just changed the way to display the data. I am sucessful in that - but need help for another issue in the same dashboard.

     

    One of my Conditinal Column is containing two types of values in it, "IN" and "OUT". Now I want one Measure/Column (as I am not sure what should be applicable here) to display total number of "IN" and one to display total number of "OUT".

     

    Hope I am clear with my issue.

    Regards

    Utsav