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?   Location Stude...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    RichOB , use

     

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

bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

RichOB , use

 

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