Count when the row has value

[Anonymous]

I have a table like this. 

Person	M1	M2	M3	M4
Peter	1	0	0	0
Jane	0	0	0	0
Tom	1	0	1	0
Mary	1	1	1	0

I want to count rows when at least one of the M1, M2, M3, and M4 has value.

[Anonymous]

@Anonymous

In your table ALL rows do have a value in ALL columns...

[amitchandak]

@Anonymous , Try a measure

row count =countrows(filter(Table, Table[M1] +Table[M2]+Table[M3]+Table[M4] >0))

[Anonymous · Accepted solution]

You can create a measure as follows:

PeopleCount = CALCULATE(

    DISTINCTCOUNT(TableName[Person]), 

    FILTER(ALL(TableName), TableName[M1] + TableName[M2] + TableName[M3] + TableName[M4] >= 1)

)

BTW, I recently developed this Power BI Smartable android app

I appreciate it if you can try it and share any feedback.