Forum Discussion
Calculate the average count of items in a table
Hello everyone, I have a table of product from a client. I need to calculate the average total price of products as well as average count of products I used this dax expression for average tota...
AKP_1 , for Average price it's enough
Average Total of Price := AVERAGE(wedding_data[Price])
Average count - it's average per buyer, per date or what? If per buyer that could be
Average Count:=COUNT(wedding_data[Product])/DISTINCTCOUNT(wedding_data[Buyer])