How to divide a Measure with calculated column to get a calculated column

[jay_patel]

Hello All,

here is my dax to get calculated column but it's giving error of Circular dependency. Also attaching Screenshot for your refrence. please help me out or you can also give another trick.

Primary-sales = CALCULATE([Primary Sales1])/'SDirectSales'[CalculatedByOverForecast]

also I cant convert the column ""calculatedByOverForecast" into measure because it's using Earlier Function.

Thanks in advance

[Ashish_Mathur]

Hi,

Even if the Primary-sales measure works, you would not want it as a calculated column formula because they do not refresh when making slicer/filter selections.  Primary-sales should be written as a measure.  To get more specific help, share some data, explain the question and show the expected result. 

[v-alq-msft]

Hi, @jay_patel 

Could you show us more details about the measure? If possible, some sample data and expected results help a lot.

Best Regards

Allan

[amitchandak]

@jay_patel , Need to how you have calculated [Primary Sales1],[CalculatedByOverForecast], share calculation

Also check - https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

Try Like

Primary-sales = Divide([Primary Sales1], [CalculatedByOverForecast])

[jay_patel]

Didn't Worked. Still Getting Same error.