User without connection

[bruno_rsp]

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?

[Anonymous · Accepted solution]

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]

@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]

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.