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:
Best answer by fwagner
View originalWrong definition of measures in semantic models
Userlevel 3
+1
Userlevel 2
+3
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 👍
Userlevel 6
+5
Hi
Can you please help us mark the best answer if you are satisfied by Frank’s answer above?
Many thanks!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
