Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count when the row has value

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, M...
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.