Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Need Assistance on Error about Circular Dependency

Hi,   I managed to create a column for variance using the dax below   Variance = CALCULATE(SUM(GRV_SalesItems[Sales Price])) - CALCULATE(SUM(GRV_SalesItems[Purchase Price]))    But when I trie...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    Please try the following formula:

    Variance = ([Sales Price] - [Purchase Price]) / [Purchase Price]

    Create the new column to classify the variance.

    Variance classification = 
IF([Variance] > 0, "Positive", 
    IF([Variance] < 0, "Negative", "Zero")
)

    Drag the date column into the slicer visual.

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rubayatyasmin's avatar
rubayatyasmin
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Anonymous 

 

Did you try using separate measures to classify variance? something like below,

Variance Classification =
VAR CurrentVariance = [Variance]
RETURN

 

see if these help:
Solved: Circular dependancy error - Microsoft Fabric Community

 

Solved: Circular dependency - Microsoft Fabric Community

 

Solved: Circular dependency.....why??? - Microsoft Fabric Community

 

Solved: Error: circular dependency - Microsoft Fabric Community
IF(
CurrentVariance > 0, "Positive",
IF(CurrentVariance < 0, "Negative", "Zero")
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

     

    Hi,

     

    I used your dax but still encountered a circular dependency as shown. Any possible option to fix my problem?