Forum Discussion

san17680's avatar
san17680
Icon for Helper II rankHelper II
3 years ago
Solved

Average 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...
Need Help
  • mlsx4's avatar
    mlsx4
    3 years ago

    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

  • san17680's avatar
    san17680
    3 years ago

    ok thanks for your time.

mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

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

san17680's avatar
san17680
Icon for Helper II rankHelper II
3 years ago

ok thanks for your time.