Formula alternative

[Anonymous]

Hello Team,

Here  is a screen shot of the two measure i m using.
The first measure is account which contains a list of all the accounts.
and the other measure is the value FYTG which is the value for those account full year to go.
I would like to create a formula that can be resumed as :
calculate ([accout value FYTG ,filter('Table' [account] ="WNNS") + calculate ([accout value FYTG ,filter('Table' [account] ="ORGNS") + calculate ([accout value FYTG ,filter('Table' [account] ="VOL") +... +...+...+...
then summing them up
I actually created a similar measure. for each account I need to sum I created a varibale within the masure  but it takes to long to load. Is there any shortcut possible ? because the account's number is much bigger than the exemple.

Best regards,
A.K

[halfglassdarkly]

Hi A.K. You should be able to use the IN operator to simplify this considerably. E.g.

calculate ([accout value FYTG] ,'Table'[account] IN{"WNNS",ORGNS","VOL"})