Forum Discussion

mb0307's avatar
mb0307
Responsive Resident
4 years ago
Solved

Percentage Total

Hi all,   I have this table showing Week Numbers, Product and a Percentage column:   How can i achieve SUM of PERCENTAGE Column (in red) correctly?     Thanks for you help.
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    mb0307 , Assume week % is a measure

    Try a measure like

    sumx(values(Table[product]),[Week%] )

amitchandak's avatar
amitchandak
Super User
4 years ago

mb0307 , Assume week % is a measure

Try a measure like

sumx(values(Table[product]),[Week%] )

  • mb0307's avatar
    mb0307
    Responsive Resident
    4 years ago

    amitchandak  perfect solution.  Thanks