cancel
Showing results for
Did you mean:
Frequent Visitor

## Count Cross Device User

Hey all experts,

I am stucked with the following problem:

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

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.

Cheers

Jörg

1 ACCEPTED SOLUTION
Microsoft

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Microsoft

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Cheers. It worked fine. Thanks a lot!

Announcements