Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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.

Average Sales.JPG

 

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

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

@Anonymous 

Give this a try.

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

jdbuchanan71_0-1662415438953.png

 

View solution in original post

1 REPLY 1
jdbuchanan71
Super User
Super User

@Anonymous 

Give this a try.

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

jdbuchanan71_0-1662415438953.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.