Forum Discussion

bruno_rsp's avatar
bruno_rsp
Regular Visitor
4 years ago
Solved

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. Measu...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

amitchandak's avatar
amitchandak
Super User
4 years ago

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.

bruno_rsp's avatar
bruno_rsp
Regular Visitor
4 years ago

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.