megera716
Board Regular
- Joined
- Jan 3, 2013
- Messages
- 146
- Office Version
- 365
- Platform
- Windows
I'm using a PowerPivot measure to determine average sale amount by customer for a particular type of product by dividing their total sales of that product by a distinct count of the item.
When it's expanded, it works beautifully:
When I collapse the row though, it throws off the average because C and E both bought some of the same items so rather than a distinct count of 39, it's a distinct count of 27.
Is there a way to fix this?
When it's expanded, it works beautifully:

When I collapse the row though, it throws off the average because C and E both bought some of the same items so rather than a distinct count of 39, it's a distinct count of 27.

Is there a way to fix this?