How to Calculate total sum divided by total count? Average Calculation..

[Anonymous]

trying to figure out the measure for How to calculate average Value.? Total sum /count 

[amitchandak · Accepted solution]

If it can work for simple Avg. then use average. Else use divide(sum(A),count(A))

Typically when we have a case like value and Qty, we use divide(Sum(Value),sum(Qty)) to get Avg price.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin