DAX query only working with an additional square closing bracket

[ashwinvoda]

Hi, I am using a simple DAX query to calculate 80 percentile from my dataset of 2G voice traffc. But the query only works with an additional closing square paranthesis. Anyone facing a similar issue here?

This is the one that works

80perc =
PERCENTILE.EXC ( '2GTraffic'[2G Voice Traffic [Erl]]], 0.80 )

And this one throws an error, while this is the one that should work

80perc =
PERCENTILE.EXC ( '2GTraffic'[2G Voice Traffic [Erl]], 0.80 )

[siddharth1k]

In your example
'2GTraffic'[2G Voice Traffic [Erl]]
The column name appears to have an internal square bracket ([Erl]), which is likely causing confusion. Square brackets are used for defining the column name, and having an extra set inside the column name is causing an issue.

[SamWiseOwl]

Hi @ashwinvoda 

Could you take a screenshot of your column name in the data pane please