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 

v-tejrama's avatar
v-tejrama
Community Support
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