Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Average Sales DAX code

Dear Experts   I have the below report being used by the business. I was asked to populate the average of total sales of all stores of group A for a particular week.   I do not have date in...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    3 years ago

    Anonymous 

    Give this a try.

    Avg =
CALCULATE (
    AVERAGE ( YourTable[Sales] ),
    ALLEXCEPT ( YourTable, YourTable[Week], YourTable[Group] )
)

     

jdbuchanan71's avatar
jdbuchanan71
Super User
3 years ago

Anonymous 

Give this a try.

Avg =
CALCULATE (
    AVERAGE ( YourTable[Sales] ),
    ALLEXCEPT ( YourTable, YourTable[Week], YourTable[Group] )
)