topic Re: This expression refers to Column object named 'Delivery Updates[Schedule logic]' which has an error in DAX Commands and Tips

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

Anonymous — Mon, 02 Sep 2024 10:22:01 GMT

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

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

Gabry — Mon, 02 Sep 2024 10:40:21 GMT

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/

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

lbendlin — Mon, 02 Sep 2024 10:49:11 GMT

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

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

Anonymous — Mon, 02 Sep 2024 11:21:50 GMT

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.

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

lbendlin — Mon, 02 Sep 2024 11:26:59 GMT

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

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

Anonymous — Mon, 02 Sep 2024 12:42:15 GMT

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

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

lbendlin — Mon, 02 Sep 2024 14:31:52 GMT

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-Forum/ba-p/963216

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/1447523