Whwn you define a measure, like a Sum:
The internal DAX expresion it’s wrong (but it works) as you can see with tabular editor:
Solved
Wrong definition of measures in semantic models
+4Best answer by fwagner
Thanks for your question
While the auto generated DAX measure does indeed not adhere to the best practice of fully qualifying the column with the table name, the code is not wrong (and works, as you mentioned).
As for my knowledge, the best practice was introduced and is propagated in the community mostly to be able to distinguish between other measures (that are supposed to be not fully qualified, but can), and table columns (that are supposed to be fully qualified, but don’t have to).
In the context of automatically generated models, you could say that this distinction is less important than when you code manually.
As a fellow big fan of adhering to DAX best practices, I have forwarded your suggestion to our product team 😎
Bonus points are always awarded for using TabularEditor by the way 👍
+4Thanks for your question
While the auto generated DAX measure does indeed not adhere to the best practice of fully qualifying the column with the table name, the code is not wrong (and works, as you mentioned).
As for my knowledge, the best practice was introduced and is propagated in the community mostly to be able to distinguish between other measures (that are supposed to be not fully qualified, but can), and table columns (that are supposed to be fully qualified, but don’t have to).
In the context of automatically generated models, you could say that this distinction is less important than when you code manually.
As a fellow big fan of adhering to DAX best practices, I have forwarded your suggestion to our product team 😎
Bonus points are always awarded for using TabularEditor by the way 👍
+5Hi
Can you please help us mark the best answer if you are satisfied by Frank’s answer above?
Many thanks!
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
