topic Count when the row has value in DAX Commands and Tips

Count when the row has value

Anonymous — Mon, 21 Sep 2020 07:11:47 GMT

I have a table like this.

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

Anonymous — Tue, 22 Sep 2020 05:43:05 GMT

You can create a measure as follows:

PeopleCount = CALCULATE(

DISTINCTCOUNT(TableName[Person]),

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

)

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

amitchandak — Mon, 21 Sep 2020 09:01:37 GMT

Anonymous , Try a measure

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

Anonymous — Mon, 21 Sep 2020 09:12:50 GMT

Anonymous

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