Circular dependency error in Dax measure

[pzywko01]

Hello,

my problem is that I created dependent formulas and I need to keep these dependencies in the model. 

Formulas look as below: 

KF4_a = CALCULATE([KF5_c],PREVIOUSMONTH('Date'[Date].[Date]), ALL())

KF5_a = [KF4_a]+[KF1_a]+[KF8_c]

KF5_b = CALCULATE(SUM('5 closed stock'[Value]), ALL())

KF5_c = CALCULATE(IF(MAX('Date'[Date].[Date])<=NOW(), [KF5_b], [KF5_a]), ALL())

 

Could you please advise how can I overcome this issue and keep dependencies at the same time? 

Thank you in advance!

[pzywko01]

Hi Ibendlin,

Here are the definitions of KFs: 

KF1 _a = sales value (this is not calculated but provided in data source)

KF8_a = [KF4_a]-[KF5_c]+[KF1_a]

KF8_b = SUM('8 Sales to pharm'[Values])

KF8_c = IF(MAX('Date'[Date].[Date])>NOW(), [KF8_b], [KF8_a])

I tried to create calculated measures with the same logic adding ALLEXCEPT in filters to remove the circular dependency but unfortunately after adding this measure to the matrix with dates and product names it did not show any data 😞 

[lbendlin]

Please show the definitions for [KF1_a] and [KF8_c]

One way to avoid circular references is to use calculated columns instead of measures, or to push the calculation upstream to Power Query.