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

[dinesharivalaga]

Hi Experts,

I am receiving the subjected error message when i am trying to create a custom column for below condition:

"FY Forecast > 500K". you have to sum all rows for the account, if the sum is >500K then it is key account

ex; (Albertsons RPA record has 300K, Albertsons GenAI/AI has 100K and no other Albertsons records, then it is not key account.  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.

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 ..

Thanks

DK

[lbendlin]

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

[Gabry]

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

If you want to read something about context transition https://www.sqlbi.com/articles/understanding-context-transition-in-dax/

[dinesharivalaga]

@lbendlin 

@Gabry 

I have removed Schedule logic DAX now as it is not required now.

Post that i can see the below error :

"ANZ banking group" is a account name column.

[lbendlin]

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

[dinesharivalaga]

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

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...