Average total sale given line item data

[Anonymous]

Dataset example:

SALE_ID	PRICE_SOLD
1001	10
1001	20
1002	30
1003	40

There are 3 sales, 1001, 1002, and 1003.

1001 has two line items. I need to calculate average sale total. For instance, ((10 + 20) + 30 + 40) / 3

How do I calculate that in DAX?

Thank you.

[lkalawski · Accepted solution]

Hi @Anonymous 

You can create a measure like this:

Measure = 
VAR _cntOfUsers = DISTINCTCOUNT('Table (2)'[SALE_ID])
VAR _sumOfSales = Sum('Table (2)'[PRICE_SOLD])

RETURN DIVIDE(_sumOfSales,_cntOfUsers,0)

_______________
If I helped, please accept the solution and give kudos! 😀