Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

Reply
AndreaCBS
Helper III
Helper III

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.

AndreaCBS_1-1721896794301.png


Is there anyone who has had the same problem?

1 ACCEPTED 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).


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
LinkedIn

View solution in original post

3 REPLIES 3
rajendraongole1
Super User
Super User

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!!





Did I answer your question? Mark my post as a solution!

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).


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
LinkedIn

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors