Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Circular Dependency error

Hii, I am new to power bI , As you see in the attached screenShot Im using simple DAX to get values for Allocated Capacity and Available Capacity 

Allocated Capacity = CALCULATE(SUM('Avail Cap & Alloc Cap'[Value]),'Avail Cap & Alloc Cap'[Attribute]="Allocated Capacity"),
Available Capacity = CALCULATE(SUM('Avail Cap & Alloc Cap'[Value]),'Avail Cap & Alloc Cap'[Attribute]="Available Capacity")
I got answer for Allocated Capacity but for Available it saying Circular Dependency is formed , How Circular Dependency is formed ???, Could any one help with right DAX to get values for Available Capacity Coloumn

 

Data Protection

3 Replies

  • goncalogeraldes's avatar
    goncalogeraldes
    Super User
    3 years ago

    Hi Anonymous ! Why are using calculated columns and not a Measure? Change those to measures and it will work perfectly! It is always better to use measures rather than columns as they are not stored in memory and therefore do not take space and are calculated on the fly.

     

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
    Thanks!

    You can also check out my LinkedIn!

    Best regards,
    Gonçalo Geraldes

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hey Thanks for Reply,

      But i need it in Coloums, i want Available Capacity and Allocated Capacity in Coloums , so that i can use them in Visuals to Apply Drill throgh....please help in Dax to get value in Calculated Coloumn

      (I.e) I Can't do pivot Attribute Coloum also i need Attribute Coloum