Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Matrix sub total is not adding up properly

subtotal is not adding up properly, I'm not using measure it is simple matix, would anyone please help, thanks  
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , this is % so should not add up.

 

Make sure you formula should be like 

measure = divide(sum(Table[Value]), sum(Table[Value2]))

 

if you want some or change the way avg work

sumx(summarize(Table, Table[Project],"_1",[Measure]),[_1])