Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Praj
Helper I
Helper I

How to find users who have never logged in

Hi Everyone,

 

I am stuck in a problem where I need to find the list of users who have never logged in to a site.

 

I have below table "All Users" which has list of all users who have access to our site

Praj_0-1683889371807.png

 The other table has list of users who have logged into our site and date of login as shown below

Praj_1-1683889418555.png

 

I am trying to create a visual similar to below where i am trying to find a table which shows the list of users who have logged in and not logged into our site. But I am stuck doing the latter. is there any way to do the same in DAX or any filter which can perform that activity?

Praj_2-1683889555314.png

 

 

Thanks in advance, appreciate any approach or solution for this problem.

 

1 REPLY 1
tamerj1
Super User
Super User

Hi @Praj 

what do you mean by "users who have logged in and not logged into our site"?

also how would you like the date to interact with the result?

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.