Forum Discussion

RichOB's avatar
RichOB
Post Partisan
1 year ago
Solved

Count measure by end_date

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?

 

LocationStudentMoved_On_Date
Bristol101/04/2024
Bristol201/04/2024
Bristol311/04/2024
Bristol4 
Bristol5 
London601/05/2024
London701/08/2024
London8 
London9 


Thanks

Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    RichOB , use

     

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

2 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    1 year ago

    RichOB , use

     

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

  • Cookistador's avatar
    Cookistador
    Super User
    1 year ago

    Hi RichOB 

     

    You can use the same approach

     

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