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

     

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.

  • danextian's avatar
    danextian
    Super User
    2 years ago

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

    • nabilassellalou's avatar
      nabilassellalou
      Regular Visitor
      2 years ago

      have email to send table?

      • danextian's avatar
        danextian
        Super User
        2 years ago

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