Copied DAX expression does not work

Anonymous — Tue, 18 Oct 2022 14:45:24 GMT

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

Re: Copied DAX expression does not work

Greg_Deckler — Tue, 18 Oct 2022 14:47:53 GMT

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

topic Re: Copied DAX expression does not work in DAX Commands and Tips

Copied DAX expression does not work

Re: Copied DAX expression does not work