Forum Discussion
rnagallatav
6 years agoNew Member
Need Help with Average Total value
Dear All, Greetings! I am loading my calculated data from excel into Power BI. After loading, the "totals row" auto-generated by Power BI is summing the average column values as well. I want the av...
- 6 years ago
rnagallatav , try like
divide(sum(A),sumx(Table,table[A]+table[B]))Mark column as % column. Not need to multiply by 100
amitchandak
6 years agoSuper User
rnagallatav , try like
divide(sum(A),sumx(Table,table[A]+table[B]))
Mark column as % column. Not need to multiply by 100