Forum Discussion

MTME's avatar
MTME
Helper I
7 years ago

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

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 c...
Need Help
v-diye-msft's avatar
v-diye-msft
Community Support
7 years ago

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's avatar
MTME
Helper I
7 years ago

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.