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

Anonymous's avatar
Anonymous
Not applicable
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