Forum Discussion

gladies123's avatar
gladies123
Helper I
5 years ago
Solved

aggregate

Hi,

Please help me to find a measue for this issue. Herewith i have attached an image for your reference

 

 output should like sum of population for india it should be displyed as 60 respective of each state, like wise other countries also..

 

Regards,

Gladies

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    hi gladies123 

     

    Your Measure would look like

     

    Total_Sum = CALCULATE(sum('Table'[Population]),ALL('Table'[State]))
     
    Thanks!
     
    PS: Please accept the post if the solution works!!! 🙂

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    hi gladies123 

     

    Your Measure would look like

     

    Total_Sum = CALCULATE(sum('Table'[Population]),ALL('Table'[State]))
     
    Thanks!
     
    PS: Please accept the post if the solution works!!! 🙂