Count measure by end_date

[RichOB]

Hi, I have student accommodation and need to count the number of students who have left a location based on their end date.

What measure would show this figure as 5, please?

Location	Student	Moved_On_Date
Bristol	1	01/04/2024
Bristol	2	01/04/2024
Bristol	3	11/04/2024
Bristol	4
Bristol	5
London	6	01/05/2024
London	7	01/08/2024
London	8
London	9

Thanks

[Cookistador]

Hi @RichOB 

You can use the same approach

StudentsLeftCount =
CALCULATE(
COUNTROWS('YourTableName'), //
NOT(ISBLANK('YourTableName'[Moved_On_Date])) 
)

[bhanu_gautam · Accepted solution]

@RichOB , use

DAX
StudentsLeft =
CALCULATE(
COUNTROWS('YourTableName'),
NOT(ISBLANK('YourTableName'[Moved_On_Date]))
)