How to calculate Active user or User in GA4 with Power BI

[Anonymous]

Hi all,

Does anyone know how to use dax to calculate the number of Google analytics 4 GA4 active users or users?

This is definition below

The number of distinct users who visited your website or application. An active user is any user who has an engaged session or when Analytics collects:

• the first_visit event or engagement_time_msec parameter from a website
• the first_open event or engagement_time_msec parameter from an Android app
• the first_open or user_engagement event from an iOS app

Thanks,

[Chris10an]

Hi HarryB

I am troubled with the exact same challenge and can see that it is marked as "Solved".

Can you please share the solution with me?

[Anonymous]

@Chris10an I am using a tool called windsor.ai to take data from GA4 I also believe within PBI there is a GA4 connector.

To get the active users right for your tables or chart I would advise creating several tables. I mean do not put all of your data under one single tables because PBI aggregator data in a different way. It will start to sum up data from columns that you do now want it to.

Then for my table data I used this calculation to create a measure for my users. 

Users =
CALCULATE(SUM(ga4_traffic_data[data.users]))

So for my table 1 which has conversions and learners and users I simply drop in the measure and it calculates the users just fine. You will have to change ga4_traffic_data[data.users to what ever your data reference is.

I use the same measure in a different table for a table with office location and conversions the active users calculate just fine.

Keep your column data small in seperate tables and you will be fine

[Wilson_ · Accepted solution]

Hey Harry,

Seems difficult to do with literally zero knowledge of your data model. Can you please share a sample pbix file? (If you don't know how, please check the pinned thread in the forum.)