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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.