Average Sales DAX code

[Anonymous]

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 my dataset, there is only weekyear, month and year.

Can anyone please help me with the DAX code to achieve the average sales for a particular week.

Thanks
Mahad

[jdbuchanan71 · Accepted solution]

@Anonymous 

Give this a try.

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