Forum Discussion
User without connection
good evening
I created this measure
UserOff = var cc1 = DISTINCTCOUNT(License[IdUser]) return if (cc1>0, blank(), "No access")
to know which users have not accessed the system in the month.
Measure above combined with the Iduser me field lists users who have not actually logged in.
Measure worked correctly.
But I need to count and show the amount of these users who have accessed.
Any tips on how to do it?
Hi bruno_rsp ,
Are you want to mark the inactive users?
If so you could use VALUES() function like below:
Column = var activeuser = CALCULATETABLE(VALUES(LicenceTotvs[IdUser]),FILTER(LicenceTotvs,LicenceTotvs[month] = UserAss[month])) return IF(UserAss[IdUser] in activeuser,"active","inactive")Best Regards,
Jay
3 Replies
bruno_rsp , you should get that using
DISTINCTCOUNT(License[IdUser])
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.Hi, amitchandak.
Hello, amitchandak. How are you? I use exactly this DISTINCTCOUNT function. I can know the number of users who have connected to the system. I can also find out how many active users I have. Example: 35 users connected. I have 45 active users. I need to know which are these 10 that do not connect. I did the subtraction of active users - users who connected. Here is the formula I used: UserOn = DISTINCTCOUNT(LicenceTotvs[IdUser]) UserAss = COUNT(UserAss[IdUser]) UserOff = UserAss - UserOn Useoff is not bringing users who have not logged in in the month, it shows in a managerial way the users who have not logged in.
Hi bruno_rsp ,
Are you want to mark the inactive users?
If so you could use VALUES() function like below:
Column = var activeuser = CALCULATETABLE(VALUES(LicenceTotvs[IdUser]),FILTER(LicenceTotvs,LicenceTotvs[month] = UserAss[month])) return IF(UserAss[IdUser] in activeuser,"active","inactive")Best Regards,
Jay
