Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help with TOTAL SUM

Hello, everyone!   I have the table below: Month ID Weight January 1 10 January 2 15 January 3 20 February 4 15 February 5 20 February 6 25 March 7 20 Ma...
General Comment
Interesting Links
Need Help
Show and Tell
Tutorial Requests
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You may create measure like DAX below.

     

     

    TOTAL WEIGHT = CALCULATE(SUM(Table1[Weight]),ALLSELECTED(Table1))



Percent = DIVIDE(SUM(Table1[Weight]), CALCULATE(SUM(Table1[Weight]) , ALLSELECTED(Table1)))


or use the measure:

Percent = DIVIDE(SUM(Table1[Weight]), [TOTAL WEIGHT])

     

     

     

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi Anonymous ,

 

You may create measure like DAX below.

 

 

TOTAL WEIGHT = CALCULATE(SUM(Table1[Weight]),ALLSELECTED(Table1))



Percent = DIVIDE(SUM(Table1[Weight]), CALCULATE(SUM(Table1[Weight]) , ALLSELECTED(Table1)))


or use the measure:

Percent = DIVIDE(SUM(Table1[Weight]), [TOTAL WEIGHT])

 

 

 

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.