Forum Discussion

rnagallatav's avatar
rnagallatav
New Member
6 years ago
Solved

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...
  • amitchandak's avatar
    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