Google Analytics ATOP in Power BI

[jongoldb]

Hello!

I'm working on a dashboard configuration pulling in Google Analytics data and am having trouble with my measure for ATOP and it pulling in the right numbers. Below is the measure that I used and attached is the screenshot which shows the ATOP metric not pulling in correctly. Has anybody run into something similar?

ATOP = format([Total Time on Page]/[Total Visits]-[Total Exits],"HH:MM:SS")

[v-chuncz-msft]

@jongoldb 

You may check if the posts below help.

• https://community.powerbi.com/t5/Desktop/Yet-another-time-query/m-p/752218#M362503
• https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/m-p/63376#M56