Measure for Count of opened items older than 60 days

[ymirza]

I am looking for DAX that will count the number of Opened tasks that are older than 60 days

I have this simple table below

Task	Created
Opened	01-Dec
Closed	02-Dec
Closed	02-Dec
Closed	04-Dec
Opened	05-Dec
Opened	06-Dec
Opened	07-Dec

I will use Card to display this count

[affan]

Hi @ymirza,

You can use the below measure

Measure = CALCULATE(COUNTROWS(Table1),Table1[Task]="Opened" , Table1[Created]<=TODAY()-60)

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

Regards,

Affan

[ymirza]

Hi @affan thanks for quick response. Yes this is what I need but right now the value returned is "Blank", how do I have Zero or '0' in the count?

[affan · Accepted solution]

@ymirza

As your data is only showing the values from Dec, so no values befor 60 days. To avoid the blank in the count measure use below measure instead.

Measure = var _count=CALCULATE(COUNTROWS(Table1),Table1[Task]="Opened" , Table1[Created]<=TODAY()-60)
return
IF(ISBLANK(_count),0,_count)

[ymirza]

Thanks Affan for the quick support