Forum Discussion

orangeatom's avatar
orangeatom
Icon for Resolver I rankResolver I
8 years ago
Solved

SUM total for allselected values

Hi, I can't seem to get a good direction for this problem. My problem is calculating an aggregated SUM and showing the total per rows while filtering, example of matrix below: Site, Users, Total Use...
Need Help
  • orangeatom's avatar
    orangeatom
    8 years ago

    Thank you to alexei7Anonymous, Due to a bit of differences in my model the allselected would have worked however for my model the following resolved my issue:

    Calculate(

    SUM(LOOKUP[User]), 
    ALL(FACT[Country])

    )

alexei7's avatar
alexei7
Icon for Continued Contributor rankContinued Contributor
8 years ago

Are you able to share a version of your model (obviously removing any sensitive data that you need to)?

 

I don't really understand your model from what you've said.

 

Thanks

Alex

orangeatom's avatar
orangeatom
Icon for Resolver I rankResolver I
8 years ago

Hello alexei7, Yes certainly, i'm working on it and send a note.

  • orangeatom's avatar
    orangeatom
    Icon for Resolver I rankResolver I
    8 years ago

    Thank you to alexei7Anonymous, Due to a bit of differences in my model the allselected would have worked however for my model the following resolved my issue:

    Calculate(

    SUM(LOOKUP[User]), 
    ALL(FACT[Country])

    )