Count Cross Device User

[drive007]

Hey all experts,

I am stucked with the following problem:

I have one table with login entries of users with the following columns

Date - userid - logintype

We have two login types:

1 - desktop

2 - app

I can easily calculate how many people logged in per month via app or desktop, however I dont know how to count the number of users who have logged in with both (so have table entries with logintype=1 AND another entry with logintype=2).

I would like to calculate:

How many users are cross device users per day (logintype =1 AND logintype=2)

How many users are cross device users per week (logintype =1 AND logintype=2)

How many users are cross device users per month (logintype =1 AND logintype=2)

I thought I need to create some kind of calculated / Summarized table for this. But unfortunately it did not work. Not sure whether there is an easy workaround I missed.

I appreciate your help

Cheers

Jörg

[v-cherch-msft · Accepted solution]

Hi @drive007

You may try to add 2 columns for your table. One is Month column and the other is ‘Week of Month’ column as below picture. You may go to Query Editor->Add Column->Date to get ‘Week of Month’ column. Then you may try to create a measure as below:

Measure =
VAR a =
    SUMMARIZE ( Table1, Table1[userid], "a1", DISTINCTCOUNT ( Table1[logintype] ) )
RETURN
CALCULATE ( DISTINCTCOUNT ( Table1[userid] ), FILTER ( a, [a1] = 2 ) )

 

Regards,

Cherie

[drive007]

Cheers. It worked fine. Thanks a lot!