Forum Discussion
PBI DAX Autocompiler doesn't work
I'm traying to write a dax formula, but as you can see the autocompiler doesn't show the table Purchase Order but only the Purchase Orders appear.
Is there anyone who has had the same problem?
Hi there Anonymous
If you begin a measure with a table reference immediately after the equals sign, the only acceptable table reference (to Intellisense) would be a table that contains at least one measure, since Intellisense assumes you are starting to write a measure reference of the form 'Table'[Measure].
By any chance does 'Purchase Orders' contain at least one existing measure, while 'Purchase Order' contains no measures?
In any case, I would not recommend including a table name with a measure (if that is what you were doing).
3 Replies
Hi Anonymous - as per my observation, Purchase Order is capitalize word, can you try to add 'Purchase Order'
Instead of purchase order .the table name is consistent and correctly spelled.
Check there are no leading or trailing spaces or special characters in the table name. These can sometimes cause issues with recognition.
Hope it helps
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!Hi there Anonymous
If you begin a measure with a table reference immediately after the equals sign, the only acceptable table reference (to Intellisense) would be a table that contains at least one measure, since Intellisense assumes you are starting to write a measure reference of the form 'Table'[Measure].
By any chance does 'Purchase Orders' contain at least one existing measure, while 'Purchase Order' contains no measures?
In any case, I would not recommend including a table name with a measure (if that is what you were doing).
