Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Let me first explain fields of my dash board with the image.
Now let’s come to the point where I am stuck; I want to display a field where the data will be shown based on the “DPI v1 and DPA v1” as follows:
Whenever I am trying to fulfill these conditions it is showing me an error as “circular dependency”. Please help me to solve this issue. With this dashboard I am getting help in some stages from this forum – hopefully it will continue like that.
Please let me know if you need anymore information.
Regards
Utsav
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/
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
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |