Forum Discussion
Solved
Simple Count Measure
Hi, I have student housing and need the count of students who have moved on. What measure will count the "1" in the Moved_On column please?
| Location | Student | Moved_On |
| Bristol | 1 | 0 |
| Bristol | 2 | 1 |
| Bristol | 3 | 0 |
| Bristol | 4 | 0 |
| Bristol | 5 | 1 |
| London | 6 | 1 |
| London | 7 | 1 |
| London | 8 | 1 |
| London | 9 | 1 |
Thanks
hello RichOB
the following measure should help you
MovedOnCount =
CALCULATE(
COUNTROWS('YourTableName'),
'YourTableName'[Moved_On] = 1
)
3 Replies
hello RichOB
the following measure should help you
MovedOnCount =
CALCULATE(
COUNTROWS('YourTableName'),
'YourTableName'[Moved_On] = 1
)Sum( table[moved_on])
Hello RichOB
You can use simple dax
count(student)
if I am missing someting please specify the condition to count
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
