Forum Discussion
Need Assistance on Error about Circular Dependency
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.
Hi Anonymous ,
Based on my testing, please try the following methods:
1.Create the sample table.
2.Create the new column to calculate the Variance.
Variance = CALCULATE(SUM('Table'[Sales Price])) - CALCULATE(SUM('Table'[Purchase Price]))
3.Create the new measure to calculate Margin instead of calculated column.
Margin01 = CALCULATE(SUM('Table'[Variance]) / SUM('Table'[Purchase Price]))4.The result is shown below.
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.
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
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.