Forum Discussion

nabilassellalou's avatar
nabilassellalou
Regular Visitor
2 years ago
Solved

DAX

I have a data table on several columns, I want to count the number of "yes" rows for a single M1 and M4 (another column) for the same identifier because there are several M1 and M4 which are repeated for the same identifier.

 

Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi nabilassellalou ,

     

    Assuming you want to count the rows in Moment Mains that contain M1 or M4 and which value in Confirmite Mains is Oui (as you did not provide a sample result), try this formula. Replace M1 with M4  if computing for M4.

    M1 = 
CALCULATE (
    COUNTROWS ( Feuil1 ),
    FILTER (
        ALLEXCEPT ( Feuil1, Feuil1[ID] ),
        CONTAINSSTRING ( Feuil1[Moment mains], "M1" )
            && Feuil1[Conformité mains] = "Oui"
    )
)

     

13 Replies

  • danextian's avatar
    danextian
    Super User
    2 years ago

    Hi nabilassellalou 

    This is  just a sample formula based on the information provided.

    CALCULATE (
    COUNTROWS ( 'table' ),
    'table'[M1 column] = "yes",
    'table'[M4 column] = "yes"
)

    If this doesn't address your question, please provide a workable sample data (not an image) and your expected result from that sample data.

  • nabilassellalou's avatar
    nabilassellalou
    Regular Visitor
    2 years ago

    I post images of columns of the used table. I would like to count the number of yes for a single M1 or M4 for same identifier