The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
26 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
31 | |
11 | |
10 | |
10 | |
9 |