Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Total for Avg Column does not AVG properly

HI, I am still learning BI and need your help on the below:   First problem is the total for the avg column does not average properly (have tried, sumx and avgx)     Second problem, is my ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous ,

Try like

AverageX(summarize(Table,Table[Origin],"_1",[Avg KGS per HBL]),[_1])