Forum Discussion
RSCustomDaxFilter column name with square brackets
Hi Max_WH ,
Thank you Aala_Ali for the workaround suggestion.
You're absolutely right to dig into escaping syntax, but unfortunately, RSCustomDaxFilter does not support escaping nested square brackets within column names. The parser expects a clean [Table].[Column] format, and any additional brackets inside the column name will break validation.
Unlike DAX or M expressions where certain escape sequences might be allowed, RSCustomDaxFilter is a custom expression used in paginated reports and doesn’t offer a way to escape or quote complex column names. It treats square brackets as structural delimiters, not literal characters.
Warm Regards,
Chaithra E.
Hi Max_WH ,
The issue here isn’t with RSCustomDaxFilter itself, but with how the column name is being referenced — the inner square brackets in your column name cause parsing errors.
Why this happens:
RSCustomDaxFilter expects a straightforward [Table].[Column] syntax, but your column is Product[Product Division Label] inside another bracket, which confuses the parser.
Solution Options:
Rename the Column
If possible, rename your column in the model to avoid inner brackets:
'Prod'[Product Division Label]
or
'Prod'[Product_Division_Label]
Then use:
RSCustomDaxFilter(
@ProductProductDivisionLabel,
EqualToCondition,
[Prod].[Product Division Label],
String
)
Create a Calculated Column as an Alias
If you can’t rename the original column:
Create a calculated column with a clean name:
ProductDivisionLabel_Alias = 'Prod'[Product[Product Division Label]]
Use the alias in your filter:
RSCustomDaxFilter(
@ProductProductDivisionLabel,
EqualToCondition,
[Prod].[ProductDivisionLabel_Alias],
String
)
Let me know if this works — if it does, please mark this as the accepted solution so others can find it, and feel free to give kudos 👍.
Thank you!
Yes, that's RSCustomDaxFilter definition itself.
But would like to know if there is anyway to escape the column square brackets in the formula....
Hi Max_WH ,
Thank you Aala_Ali for the workaround suggestion.
You're absolutely right to dig into escaping syntax, but unfortunately, RSCustomDaxFilter does not support escaping nested square brackets within column names. The parser expects a clean [Table].[Column] format, and any additional brackets inside the column name will break validation.
Unlike DAX or M expressions where certain escape sequences might be allowed, RSCustomDaxFilter is a custom expression used in paginated reports and doesn’t offer a way to escape or quote complex column names. It treats square brackets as structural delimiters, not literal characters.
Warm Regards,
Chaithra E.