Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
5 years ago

A circular dependency was detected

Hi all   I am building a new column on the table SKU by line - Official, which basically is a multiplication of:   A measure [BPM conversion]* a calculated column [Mix by product] * Max available...
Need Help
Show and Tell
o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
5 years ago

Hi PaulDBrown 

 

If I try to wrap the if colum with calculate, this happens:

 

 

Columns are underlined with red.

 

Regards.

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Apologies since I can't see the image clearly. However, try putting the IF expression in a VAR and then do the CALCULATE with ALLEXCEPT as the RETURN expression 

  • o59393's avatar
    o59393
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    Hi PaulDBrown 

     

    You can click on the image and it will expand. What column should I use within allexcept?

     

    Please click in image below to zoom in:

     

     

    Regards.

    • PaulDBrown's avatar
      PaulDBrown
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Yes, sorry, I was posting from my phone so couldn't see the image clearly.
      I would try the 'SKU by line - Official' [Month] field for the ALLEXCEPT. It's hard to tell because not all the table fields are visible in the image).
      Ideally it should be the field with the highest granularity in the table.

      • o59393's avatar
        o59393
        Icon for Post Prodigy rankPost Prodigy
        5 years ago

        Hi PaulDBrown 

         

        Can you please have a look at my pbix?

         

        I don't know how to use calculate + allExcept with an if function:

         

         

        Can you please further advise?

         

        Thanks!