Forum Discussion
san17680
Helper II
Helper IIAverage Sales Per customer not working
Hi All, i have tried to get avg sales per cust, but its not working, it somehow shows total sales. here is my formula AVG SALES PER CUST = AVERAGEX(VALUES(Customer[Customer]),SUM(Sales_data[Sales...
But total sales measure sums the values as in option 2, isn't it?
Then, it wouldn't be possible to achieve result in 1
ok thanks for your time.
mlsx4
Memorable Member
Memorable MemberSorry but I have lost myself. Are you using two different measures? Because the one I answered first was related to customers
san17680Helper II
Helper IIi think I did not make myself clear.
this is not related to current question, but when i do avg sales per day here is formula for that
AVG SALES PER DAY = AVERAGEX(VALUES('Calendar'[Date]),[TOTAL_SALES])
it uses a sales measure.
Now coming to the question,
for Avg sales per customer why are we using average in measures and not sales like AVG SALES PER DAY. i am confused about this.
Thanks
- mlsx4
Well, I just tried to correct your formula, but I don't really now what you are trying to achieve or which is your expected output. Anyway, I think it should work if you use total sales too. It's difficult for me to realize your expectations without the data/expected result. What are you trying to achieve 1 or 2?