Replacing a list in set analysis with a variable

[vmcintyre]

Hi All, 

I have a calculation that looks like this:

sum([Supplier Legal Entity]={'option1','option2','option3'}>}[Supplier Legal Entity]).

I want to replace the list 'option1 etc.. with a variable so that if I need to change it, I only need to change it in one place. 

created a variable with the list, but when I tried to insert the variable back into the calculation, it failed. 

I'm afraid I can't share any examples. 

Many thanks in advance!

[Kushal_Chawda · Accepted solution]

Create a variable as below

Name :vSLE 

Value : 'option1','option2','option3' (Note : Don't put "=" in value)

Now use below expression

sum({<[Supplier Legal Entity]={$(vSLE)}>}[Supplier Legal Entity])

[vmcintyre]

Thank you!!