Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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])
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])
Thank you!!