Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Formula alternative

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


1 Reply

  • halfglassdarkly's avatar
    halfglassdarkly
    Responsive Resident

    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"})