Forum Discussion

Gunter's avatar
Gunter
New Member
3 years ago

Calculated table: Column 'Planned Eng.' cannot be found or may not be used in this expression.

Dear experts,

 

I struggle to understand below:

 

 

Engagements = 
CALCULATETABLE(
    ADDCOLUMNS(
        SUMMARIZE('Assignees', 'Assignees'[Assignee], "Actual Engagements", COUNT('Cards'[Activity Type])),
        "Planned Engagements",
        CALCULATE(
            SUM('KPI Data'[Planned]),
            FILTER(
                'KPI Data',
                'KPI Data'[Assignee] = 'Assignees'[Assignee] &&
                'KPI Data'[KPI] = "Engagement"
            )
        ),
        "Achievement",
        DIVIDE([Actual Engagements], [Planned Engagements])
    ),
    LEFT('Cards'[Activity Type], 2) = "EN" && 'Cards'[Status] = "Completed"
)

 

 

 

It works except for the line DIVIDE([Actual Engagements], [Planned Engagements]) where it says

"Column 'Planned Engagements' cannot be found or may not be used in this expression."

 

How can I calculate the "Achievement" Column? And why is it an error at all? Thank you!

Need Help

2 Replies

  • pratyashasamal's avatar
    pratyashasamal
    Memorable Member
    3 years ago

    Hi Gunter ,

    I have experienced similar issues before when view column names have changed. Sometimes refreshing the Preview in Power Query is sufficient to fix it or selecting 'Choose Columns' in PQ and ensuring all are selected. 

    Thanks,
    Pratyasha Samal
    Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
    If you found this post helpful, please give Kudos C
    • Gunter's avatar
      Gunter
      New Member
      3 years ago

      Thank you - I think it must be an error regarding my understanding of how to write this statement. Let's see if someone else had an idea as well.