Simple Count Measure

[RichOB]

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

[pankajnamekar25]

Hello @RichOB 

You can use simple dax

count(student)

if I am missing someting please specify the condition to count

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[Cookistador · Accepted solution]

hello @RichOB 

the following measure should help you

MovedOnCount =
CALCULATE(
COUNTROWS('YourTableName'), 
'YourTableName'[Moved_On] = 1
)

[Deku]

Sum( table[moved_on])