Forum Discussion

MichaelG1117's avatar
MichaelG1117
Helper I
2 years ago
Solved

Create Measure: Average Sales Per Week Per Country

Hi Everyone,   I need to create a measure "Average Sales Per Week Per Country".    I created a date table with 'WeekNum'.    I used the following to create the Sales per week per country and wa...
MichaelG1117's avatar
MichaelG1117
Helper I
2 years ago

Hi Anonymous 

 

Thanks for your response.  Everything in that equation is good except it does not allow me to put in: 

 "Total Sales", 'Orders'[OrderQuantity] * 'Orders'[SalesPrice]

I replaced this line with what it did allow, namely a measure I had created previously "Order Amount": 

Order Amount = CALCULATE(Sumx('Orders','Orders'[OrderQuantity]*'Orders'[SalesPrice]), USERELATIONSHIP('Date Table'[Date], Orders[OrderDateKey]))

 

But when I put this in the numbers came out wrong on the Matrix Visual. 

 

Here is the Data for the "Orders" Table: 

 

Here are the relationships: 

 

 

I created the date table. Do I need to connect it with "Territories"? 

Or do I just need to find a way to write 'Orders'[OrderQuantity]*'Orders'[SalesPrice] in your equation in a way that works? 

I am not allowed to created any calculated columns. 

 

Again, thanks for your help and any further help would be greatly appreciated. 

 

kavishchaudhary's avatar
kavishchaudhary
New Member
2 years ago

I want to understand how the no. of weeks is 55. According to my calculations the difference between 24 jan 2013 and 27 Jan 2014 is 53 weeks. Can you elaborate? I am solving the same question.