DAX

[nabilassellalou]

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.

[nabilassellalou]

I cant post table 

[nabilassellalou]

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 

[danextian]

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]

  

[danextian]

Not images please. You can copy a table and paste it  here.

[nabilassellalou]

have email to send table?

[danextian]

You can post a link to a cloud storage like One/Google Drive or DropBox.

[nabilassellalou]

https://docs.google.com/spreadsheets/d/186-uW7bnUgvSOE1t3NLTqt802rqGAsOP/edit?usp=drive_link&ouid=10...

[danextian]

link is not public

[nabilassellalou]

https://docs.google.com/spreadsheets/d/e/2PACX-1vRmTDAAKqB-x2v_FDz1TgHBU5MqHUA7CoP23w75YLEWCZDEJoZdh...

[nabilassellalou]

Its public now

[danextian · Accepted solution]

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"
    )
)

[nabilassellalou]

Thank you, it's done.