Forum Discussion

Nozama's avatar
Nozama
Helper I
1 year ago
Solved

New Syntax or a glitch?

I spent over an hour trying to understand why my measure wasn't working in this kind of a statement: Measure1 = CALCULATE ([Measure2], ALL[Table]). Then strangely found out that the measure works wi...
Need Help
  • v-tejrama's avatar
    v-tejrama
    1 year ago

    Hi Nozama ,

    Thanks for reaching out to the Microsoft fabric community forum.

     

    You're on the right track when a table name contains special characters like square brackets [], DAX requires it to be wrapped in single quotes.

    Try using this :
    Measure1 = CALCULATE([Measure2], ALL('ABCDEF [Master]'))

    This tells DAX to interpret the entire string as a single table name, avoiding syntax errors.

     

    If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

    Best Regards,
    Tejaswi.
    Community Support Team 

Nozama's avatar
Nozama
Helper I
1 year ago

I think I might have figured it out. My Table Name is actually 'ABCDEF [Master]' so I reckon if a table name ends in "]" maybe DAX needs its reference to end in "}". Can someone please confirm by testing? Thanks!

  • djurecic's avatar
    djurecic
    Super User
    1 year ago

    Interesting- I don't think that is it though. For table names ending in ] you should use '' like so for a table named Sample[Table]:

    Sample Measure = SUM('Sample[Table]'[Goal])