Calculate the Conversion Rate of Two Events in Google Analytics

[jytech]

Hello,

I'm pulling data from Google Analytics, specifically Event Action (a dimension) and Total Events (a metric). Event Actions are either a Click or an Impression (both strings). I would like to calculate the Click-Through-Rate (Click/Impression) using DAX. 

Similar to this but in Power BI: https://www.youtube.com/watch?v=YtoItmFC8Gk

It would look something like this: SUM('Google Data'[Total Events] WHERE 'Google Data'[Event Action] = "Click" / SUM('Google Data'[Total Events] WHERE 'Google Data'[Event Action] = "Impression". Can someone please help with the correct DAX syntax.

[VijayP]

@jytech 

You are Welcome , also share your Kuods by pressing 👍 Icon! 

[VijayP · Accepted solution]

@jytech  you can use this DAX. Let me know if it has any issues, mean time if you can share sample data it would be easy to provide much more clear solution.

VAR Clickevents = CALCULATE(SUM('Google Data'[Total Events]), 'Google Data'[Event Action] = "Click")
VAR impevents = CALCULATE(SUM('Google Data'[Total Events]),'Google Data'[Event Action] = "Impression")
RETURN
Divide ( Clickevents,impevents,0)

[jytech]

@VijayP thank you kind sir. It worked perfectly!