Modify count over 30days for Selected Users

[Anonymous]

Hello, 

I have a current formula which allows me to count all the users which have not logged in for over 30days 

From last 30 d =
VAR x = CALCULATE(COUNTROWS('UAC_Test'),FILTER(ALL('UAC_Test'[LastLogonDate]),'UAC_Test'[LastLogonDate] <= TODAY() - 30))
RETURN IF(x > 0, x, 0)

However, i only want to count the ones that have Enabled as True. 

So in theory i am looking for all the users that have not been active in over 30days and are still enabled. 

Sample data below:

[v-xicai]

Hi @Anonymous ,

You can create measure like DAX below.

Measure1= CALCULATE(COUNT('UAC_Test'[Name] ),FILTER(ALL('UAC_Test'),'UAC_Test'[Enabled] = "TRUE"&&'UAC_Test'[LastLogonDate] <= TODAY() - 30))

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I've added the code and modified it to my varilables and it says "Can't display the visual" 

[v-xicai · Accepted solution]

Hi  @Anonymous ,

You can try to create column Datediff like DAX below.

Datediff = DATEDIFF('UAC_Test'[LastLogonDate] ,TODAY(),DAY)

Then change the meaure1 .

Measure1= CALCULATE(COUNT('UAC_Test'[Name] ),FILTER(ALL('UAC_Test'),'UAC_Test'[Enabled] = "TRUE"&&'UAC_Test'[Datediff] <= 30))

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.