This expression refers to Column object named 'Delivery Updates[Schedule logic]' which has an error

Question

Hi Experts,I am receiving the subjected error message when i am trying to create a custom column for below condition:"FY Forecast &gt; 500K". you have to sum all rows for the account, if the sum is &gt;500K then it is key accountex; (Albertsons RPA record has 300K, Albertsons GenAI/AI has 100K and no other Albertsons records, then it is not key account.&nbsp; Albertsons RPA record has 300K, Albertsons GenAI/AI has 200K then it is key account) . RPA and GenAI is a offertype , if we have same account names but different offertype then we have to sum FY forecast for those same account and mark it as YES or NO.&nbsp;DAX i created below got an error based on the previous DAX error :I don't know why it is getting this error message .Please help to solve this ..&nbsp;ThanksDK&nbsp;

gabry · Answer

I think it is because you used CALCULATE inside a calculated column, so the previous column in error gets inside your new filter context. You have to fix Schedule Logic formula. Or exclude this column from the formula for key account role 2 like adding removefilter('table'[schedule logic])to your calculate
&nbsp;
If you want to read something about context transition https://www.sqlbi.com/articles/understanding-context-transition-in-dax/
&nbsp;
&nbsp;

lbendlin · Answer

You first need to correct the [Schedule Logic]&nbsp; column.

anonymous · Answer

lbendlin&nbsp;Gabry&nbsp;I have removed Schedule logic DAX now as it is not required now.Post that i can see the below error :&nbsp;"ANZ banking group" is a account name column.

lbendlin · Answer

Filters need to be tables or True/False.&nbsp; You tried to specify a column as a filter.

anonymous · Answer

ok what should be the DAX formula then for my scenario ? Can you please help to explain more on this ..

Forum Discussion

This expression refers to Column object named 'Delivery Updates[Schedule logic]' which has an error

6 Replies