Forum Discussion

Anonymous

Not applicable

2 years ago

Solved

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?

OwenAuger
2 years ago
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

rajendraongole1
Super User
2 years ago
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!!
- Anonymous
  Not applicable
  2 years ago
  It's not case sensitive, and I have already tried every permutation, but thanks for you suggestions!
  - OwenAuger
    Super User
    2 years ago
    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).