cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
drive007
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

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

1 ACCEPTED SOLUTION
v-cherch-msft
Microsoft
Microsoft

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 ) )

 a.jpg1.png

 

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.

View solution in original post

2 REPLIES 2
v-cherch-msft
Microsoft
Microsoft

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 ) )

 a.jpg1.png

 

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.

View solution in original post

Cheers. It worked fine. Thanks a lot!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors