Seeking Advice on Bracket Usage in Semantic Model

[Khalid1988]

Hi everyone,

I'm working on a new Semantic Model, and I wanted to share something I'm encountering. The names of the measures and columns in the model are formatted like this: `Production [Kwh]`, with spaces and square brackets.

Whenever I try to use these measures or columns in scripts, I often have to add more brackets than expected. For example:

```DAX

Branch1Prod = CALCULATE(
Production [Kwh],
Branch[branch [no]]] = "Branch1"
))
```

The engine forces me to add the extra red bracket, and then the measure doesn't work properly.

Could this issue be related to the use of brackets in the names of columns and measures, or might it be something else?

Thanks!

[Krina234pestro]

Hello,

You are sharing some advice on DAX syntax, specifically about referencing a single ] in a measure name. Here’s a cleaner version of your DAX code snippet: CALCULATE(
SUM(Efficient[Consumption [kWh/t Product]]),
FILTER(Efficient,
Efficient[Consumption [kWh/t Product]] > 50
)
)

If the measure isn’t working correctly, it might be due to validation issues or incorrect metric maximtimeclock references. 

Hope that helps. 

[uzuntasgokberk · Accepted solution]

Hello @Khalid1988,

In the DAX syntax, you have to use ]] in order to reference a single ] in a measure name.

    CALCULATE(

        SUM(Efficient[Consumption [kWh/t Product]]]),

        FILTER(Efficient,

            Efficient[Consumption [kWh/t Product]]] > 50

            )

          )

İf your measure doesn't work properly that you mean the output of measure values are wrong. Probobly you need to check validation values or whether you wrote metric correctly or not

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |