Forum Discussion

wangjuan303's avatar
wangjuan303
Icon for Helper III rankHelper III
3 years ago
Solved

How to get total value

Hi All, I need to create total measure, like under ,

I hope 13400 to show on Yellow part, 

when slicer change, sales total will change too, 

want show Sales total in "Total column" 

my total measure code is : 

Total = CALCULATE(SUM(Detail[Sales]), ALL(Detail))
please help me on this, Thank you

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi wangjuan303 ,

    In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi wangjuan303 ,

    In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu