Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Average Store Sales

I am looking at a day by day view of how many stores are open, their total sales, and what the average per store is in sales. I would want the week total to be different. The average per store would add up all the averages for the week and then the stores open is total sales divided by the average for the week. I made an excel with what I am looking for a formulas for excel would be. I need some help with formulas for the week end data. 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Nevermind I got it working with 

    SUMX(VALUES('4-4-5 Date'[DateKey]),CALCULATE(DIVIDE([Net Sales],[# Stores Day])))

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous  - You can add the following 2 measures:

    Average Sales = 
SUMX(
    'Daily Sales', 
    DIVIDE([$ Sales],[# of stores])
)
    Stores Measure = 
DIVIDE(
    SUM('Daily Sales'[$ Sales]),
    [Average Sales]
)
    I hope this helps. If it does, please Mark as a solution.
    I also appreciate Kudos.
    Nathan Peterson
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      The first formula doesn't help me get to the $17,624 because I dont have # of stores for the total of the week. I need to add up the averages for each day of the week. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Anonymous  - Could you share your pbix?