Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Store Sales Average calculation help request

Dear Experts.

 

I have a Store slicer with the single selection option in it. My report displays the sales information of that Store week wise. I was asked to get the average sales for each week.

 

Average Sales = Total Sales(for all the stores) / Total Sales of the store(selected on the slicer) for that period.

 

Please can someone help me with your valualble input to achieve this.

 

Thanks
Mahad

  • Hi Anonymous 
    Please try

    Average Sales =
    VAR StoreSales =
        SUM ( Sales[Sales] )
    VAR TotalSales =
        CALCULATE ( SUM ( Sales[Sales] ), ALL ( Stores[Store Name] ) )
    RETURN
        DIVIDE ( TotalSales, StoreSales )

1 Reply

  • tamerj1's avatar
    tamerj1
    Community Champion

    Hi Anonymous 
    Please try

    Average Sales =
    VAR StoreSales =
        SUM ( Sales[Sales] )
    VAR TotalSales =
        CALCULATE ( SUM ( Sales[Sales] ), ALL ( Stores[Store Name] ) )
    RETURN
        DIVIDE ( TotalSales, StoreSales )