dependency error in the measure

[illusionek]

Hello

I have a data model/PowerPivot, which I have been using for few months and all was working well until this morning.

All of the sudden I have a number of measures that worked well last week but today come up with an error: "dependency error in the measure" even though I have not changed calculations at all.

I have a Table1 with my sales data and below measure goes into error:

=SUMX('Table 1','Table 1'[Order Qty]*'Table 1'[Sales Price])

The Sales Price is taken from each row in Table 1 and Order Qty is another measure in the model, which is working fine:

SUM('Table 1'[Ordered Qty])

As far as I can see only iteration functions seem to be affected by the dependency error. Any ideas what could happen?

 

[illusionek]

Any thoughts on this?

I found a temporary solution where I amended SUMX where I replaced measure Order Qty with Ordered Qty which is a value from a table. However it has been working fine for a really long time so I would love to understand whats changed. Also in the past I read it is better to use measures for all calculations rather then values directly from tables, so thats the reason I created them in the first place


Many thanks