Copied DAX expression does not work

[Anonymous]

Dear community, hopefully one of you can help me out with the issue I am currently dealing with.

first a bit of context;

I am recreating a power BI report from an example, that contains a data table, a date table, and a measures table.

the data table contains personnel information, and consists of "closing" count of employees and "opening" count of employees. It shows at a given month what the amount of personnel was at the start of the month (opening), versus at the end of the month (closing).

the measures table will consist of 2 measures; how many "opening" workers vs. how many "closing" workers. In the example the formulas are;

ClosingWorkers = CALCULATE(count('Headcount development and turnover (2)'[Person Number]), 'Headcount development and turnover (2)'[Status] = "Closing")

 and 

OpeningWorkers = CALCULATE(count('Headcount development and turnover (2)'[Person Number]), 'Headcount development and turnover (2)'[Status] = "Opening")

All went well untill I tried to copy the DAX formula from the measures table. I receive the error:

"The expression specified in the query is not a valid table expression."

Which is strange, because everything is correct according to the example file. and CALCULATE and COUNT are both expressions accepted by Power BI. Does anyone know why this error might occur? My suspision is that it has something to do with the difference in settings or installations, but I am far from an expert. 

I am looking forward to your replies, many thanks in advance!

Kind regards,

Robin

[Greg_Deckler · Accepted solution]

@Anonymous Did you paste this into a calculated Table expression instead of a measure expression?