Forum Discussion
LYeo87
Helper II
Helper IIVisual Help
Hi Have 2 graphs - the 1st is showing me the percentage of jobs over the year - so for example Dec equals 40.94%. I then have a second graph that shows me these jobs broken down into 2 x categori...
amitchandak
Super User
Super UserLYeo87 , You have try measures like
divide(sum(Table[total]),calculate(sum(Table[total]) , allexcept(Table, Table[month Year])))
divide(sum(Table[total]),calculate(sum(Table[total]) , filter(allselected(Table), Table[key#] =max(Table[month Year]))))
also refer
https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390