Forum Discussion
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 with the syntax [ Table }.
Is there something I am missing or is this a glitch?! Screenshot attached.
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
7 Replies
Hi Nozama
This fails because ALL[Table] is incorrect syntax - missing parentheses - ALL([Table])
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
It doesn't fail. It works, I just don't konw why.
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/
It is the only syntax that works! 😂
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!
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])
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
