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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

 

Is it possible to make the variance as columns instead of measure so I can add it into a slicer?

 

Plus how can i make a slicer to classify the variance based on negative, positive and zero because I tried using the if function but again encountered circular dependency

 

//NT

 

//NT

Anonymous's avatar
Anonymous
Not applicable
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.