New Syntax or a glitch?

[Nozama]

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.

[v-tejrama · Accepted solution]

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]

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!

[djurecicK2]

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])

[djurecicK2]

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/

[Nozama]

It is the only syntax that works! 😂

[Elena_Kalina]

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.

[Nozama]

It doesn't fail. It works, I just don't konw why.