Forum Discussion
New Syntax or a glitch?
- 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
Hi Nozama ,
That is strange- seems like it should not work.
I think of { } as being used to contain a list, like with the IN function.
https://www.sqlbi.com/articles/the-in-operator-in-dax/
- Nozama1 year agoHelper I
It is the only syntax that works! 😂