Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Weighted Average - Large Dataset

Hi, I am new to power BI.    Is “Summarize Table” a good option for a large data set approx(60 million rows)? Reason why I need this functionality is that I use "Weighted average" for all my Aggr...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , You formula should avoid row calculation. You should have measure like

 

Divide(Sum(Table[A]) , Sum(Table[B]))

or

 

Divide(Sum(Table[A]) , count(Table[A]))