Forum Discussion

Fab117's avatar
Fab117
Helper IV
3 years ago
Solved

Circular dependency when applying LookUpValue

Hello,   I've 2 tables: 1. Table: NetReg_file Code Quantity A 5 B 3 A 4 C 6 B 4 A 2 C 5 A 3 B 1 C 4 2. ...
Need Help
  • Fab117's avatar
    Fab117
    3 years ago

    I found the issue.

    It was linked to relationship between the 2 tables:

     

    Not fully sure to understand the why, but at least solved.

     

    Thanks to all who looked at my issue.

     

    Happy new year

     

    Fab

     

  • Fab117's avatar
    Fab117
    Helper IV
    3 years ago

    Hi,

    thanks for taking time looking at my issue.

    I opened your demo file and it works perfectly.

    But, don't know why, it fails when I apply to my case.

    I scrapped all and repeated as you did (with minor spelling differences in fileads name). But still the error message:

     

    It's very strange the content of the error message as it seems that Power BI understand it has to look all in NetReg_file table

     

    • Fab117's avatar
      Fab117
      Helper IV
      3 years ago

      To be noted that if I do first the net price column creation, it works and then failed when I try to create standard price one

      => it's really when cretaing the second column that I have the issue

      • AbbasG's avatar
        AbbasG
        Memorable Member
        3 years ago

        Fab117 share your file, with sample data(remove sensitive information) to help your further.