The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
The other table has list of users who have logged into our site and date of login as shown below
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?
Thanks in advance, appreciate any approach or solution for this problem.
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?
User | Count |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
22 | |
14 | |
14 | |
9 | |
7 |