Google Analytics average order value column not integrating properly in Power BI

[MTME]

Hi, 

I'm having some issues when trying to grab my average order value from Google Analytics. 

Whenever I try to use the Date column from Google Analytics together with the Average Order Value column, it's like it accumulates all revenue in that month, rather than showing the average order value. Take this chart for example - I have set it up to show average order value by month:

However, this is not in accordance with my data for that month, but rather an accumulation of all revenue for that month, as my Analytics account shows me that my total revenue for May 2019 is $7089.61, whereas my average order value is $214.84

I tried recreating the chart using the "month of the year" data instead, which only grabs the months, and by doing this I was able to get a correct chart, showing the correct values: 

This is a fine temporary solution, but in the long run, I would like to be able to use the Date data from Google Analytics, as it provides me with more options in terms of filtering and presentation.

Does anyone know why it accumulates my average order value, rather than showing only the average from the specific periods, when using the Date column from Google Analytics? Or how I make it behave like I want it to?

[v-diye-msft]

Hi @MTME ，

It would be appreciated to share us your dummy pbix that would be easier for us to replicate the issue. Based on my understanding, I would like to suggest you use the measure to generate the Avg,value on the category of month. like this:

First create a measure ValueSum:=SUM(Table1[Value])

Avg.value=AVERAGEX(VALUES(Table1[DateMonth]),[ValueSum])

Then applied the measure into visual.

Best regards,

Dina Ye

[MTME]

I tried making these measures, but it seemingly didn't give me the desired result.

Generally it seems like my issue is just that when I select the "Avg. Order Value" and put it up on a chart that shows time, it sums all the values up for the period. 

So for example, say I have 2 days in a month that both have an average order value of $200, then if I filter my chart for just those 2 days, it'll tell me the average order value of $400. 

I'm quite new to PBI, so I'm not sure how I would go about preventing it from doing this, and instead giving me the data I want.