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

Hi orangeatom,

 

Try the following and see if it helps (replacing "Table1") with your own table name:

 

Total Users = CALCULATE(sum(Table1[Users]),ALLSELECTED(Table1[Site]))

 

 

Alex