Forum Discussion

curtismob's avatar
curtismob
Helper IV
8 years ago

Circular Dependency Using Measures

Hello,   I'm thinking what I am trying to accomplish can be done, but I'm not sure how to get around my Circular Dependency problem.   First I have this very basic calculated column below, which ...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi curtismob,

 

Can you please share a pbix file with some sample file to test? It will be help for testing and coding formula.

 

In addition, you can also take a look at following link about avoiding circular dependency:

Avoiding circular dependency errors in DAX

 

BTW, what '_mCost/SQFT Avg XXX' means? (measure or column) If it means column, i'd like to suggest you enter to query editor to use unpivot function to transform them to reduce the complex of measure formulas.

Unpivot Data Using Excel Power Query

 

Regards,

Xiaoxin Sheng

  • curtismob's avatar
    curtismob
    Helper IV
    8 years ago

    Xiaoxin,

     

    Thank you for your response.  I will have to create a modified version of the pbix, which unfortunately, may take me a while to do. 

     

    I have actually reviewed the Avoiding circular dependency errors in DAX link you referenced, I'm just not sure it applies or how to apply the suggestions.

     

    The '_mCost/SQFT Avg XXX' are monthly measures to show the cost per sqft by month and how these may increase/decrease month over month.

     

    I will work on getting the pbix created.

     

    Regards,

    curtismob