Problem with set analysys when text variable contain space or special symbol

[#1]

I can't figure out how can I overcome this issue.

I have a variable (Top1) which determines the name of 1 top selling brand: =only({<Brand= {"=rank(sum(Sales), Brand) =1"}>} Brand )

then this value is passed to textbox to get the sales for this top brand: =sum({$<Brand={$(Top1)}>}Sales),

Formula works fine if Brand doesn't have spaces or special characters. Please see the screenshot for the results:

[Miguel_Angel_Baeyens · Accepted solution]

Hello and welcome to the Forums,

I think it's because text in set analysis have to be quoted:

=sum({$<Brand={'$(Top1)'}>}Sales)

Hope that helps

[#3]

Many thanks, Miguel. It worked.