Forum Discussion

johnny19's avatar
johnny19
Frequent Visitor
5 years ago
Solved

Circular Dependency preventing second calculated column creation

Hi there,   I'm looking for some help with a DAX circular dependency error that I can't manage to get around.  I've tried using ALLEXCEPT but I've not been able to sort out my problem.  Below is a ...
Need Help
Tips and Tricks
Tutorial Requests
  • HotChilli's avatar
    HotChilli
    5 years ago

    I've never seen measures used in this way before.  I don't recommend it.

    So I think you should replace the usage of the measures in each column with the appropriate DAX - not too complicated to do.

    The DAX is a little long-winded but it looks like it will work.

    --------------

    Let me know how you get on

HotChilli's avatar
HotChilli
Community Champion
5 years ago

I've never seen measures used in this way before.  I don't recommend it.

So I think you should replace the usage of the measures in each column with the appropriate DAX - not too complicated to do.

The DAX is a little long-winded but it looks like it will work.

--------------

Let me know how you get on

johnny19's avatar
johnny19
Frequent Visitor
5 years ago

Thanks HotChili!  Feeling a bit dim that it was such a straight forward fix. But yep, like you suggested, removing the measures and replacing the references to them in the calculated columns has fixed things

 

Out of curiosity, are there any recommendations you could give to simplify the DAX?  It seems to work fine but if there are efficiencies that could be made it'd be interesting to hear

 

Thanks again for the quick response!