Forum Discussion

Qazybek's avatar
Qazybek
Frequent Visitor
8 years ago
Solved

Circular Dependency detected issue

Hello all,

 

Here is a link to my demo-table. I want to create the same table using DAX in PowerPivot Data Model but can't figure out how. The problem is a circular dependency. Can someone please help?

  • In your query, duplicate your F column. Use that column to calculate C.

8 Replies

    • SonLeThai's avatar
      SonLeThai
      Frequent Visitor

      Do you solve this case? can you share with me? i get the same issue...:(... Please help me solution.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Yes, that is going to create a circular dependency, not sure what else to say. E comes from C, F comes from C and E and C depends on F, so...

    • Qazybek's avatar
      Qazybek
      Frequent Visitor

      Thank you for reviewing. Any chance to avoid circular dependency here?

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion

        In your query, duplicate your F column. Use that column to calculate C.