Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
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?
Solved! Go to Solution.
Hi there @AndreaCBS
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).
Hi @AndreaCBS - 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!!
Proud to be a Super User! | |
It's not case sensitive, and I have already tried every permutation, but thanks for you suggestions!
Hi there @AndreaCBS
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).
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!