 • 547K Members
• 2,787 Online
• 652K Conversations

Highlighted

# 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 total
```
Average Total of Price =
CALCULATE(
AVERAGE(wedding_data[Price])
)

Here is the sample of the table
[Wedding Date], 6/1/2019, 1/2/2019, 9/1/2019, 6/1/2019, 7/7/2019
[Location], AK, NY, CO,AK, TX
[Price], \$5, \$7.5, \$6.12, \$10, \$21

Using the DAX above, one will obtain the average total price

Now I need to do the average count of product, with the right DAX,

However, I am not sure what expression to use for average count for each product.

I am suppose to get a value that if I multiply by the number of items, I will give the total sum of items.

Highlighted

# Re: Calculate the average count of items in a table

@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])`
Related Conversations
Counting Days
Tim Hunter in SQL Server on
2 Replies
How to count multiple values in a cell
Ugarte335 in Excel on
7 Replies
Count until
MBelshaw in Excel on
1 Replies
Pivot table
gabriellerocha in Excel on
5 Replies
PWA fullscreen like IE11 kiosk mode
rogihee in Discussions on
5 Replies