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 Aggregation and Group By throughout all visuals,

 

“No default aggregation to be applied while using visuals ”.
All the visuals should use weighted average and have to change based on filter/slicers 


Can someone please help in choosing the right approach to solve this problem. Because this is a very important functionality.   ?

1 Reply

  • amitchandak's avatar
    amitchandak
    Super 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]))