Forum Discussion

ayoubb's avatar
ayoubb
Helper IV
6 years ago
Solved

Checking and correcting

Hello, 

 

Please could anyone help me to correct this DAX below: 

 

Ticket résolu = COUNTROWS(FILTER(RELATEDTABLE('Détail des DS'),'Détail des DS'[Statut demande de service] = "En cours","Ouvert","En attente"))
 
i want to calculate all what is in column except "En cours" and "ouvert" and "en attente", in this column i have also "Résolu" and "cloturé" and "retraité"
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi ayoubb ,

     

     

    Try this

     

    Ticket résolu =
COUNTROWS (
    FILTER (
        'Détail des DS',
        NOT 'Détail des DS'[Statut demande de service]
            IN {
            "En cours",
            "Ouvert",
            "En attente"
        }

&&  
'Détail des DS'[Agents] IN {"A","B","C"}

    )
)

     

     


    Regards,

    Harsh Nathani


    Appreciate with a Kudos!! (Click the Thumbs Up Button)

    Did I answer your question? Mark my post as a solution!

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    ayoubb it will be easier to provide a solution if you paste sample data and expected output.

    • ayoubb's avatar
      ayoubb
      Helper IV
      6 years ago

      I want to count row for the column "Statur demande de service" except "En attente" and "En cours" and "Ouvert"

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi ayoubb ,

         

         

        Ticket résolu =
COUNTROWS (
    FILTER (
        'Détail des DS',
        NOT 'Détail des DS'[Statut demande de service]
            IN {
            "En cours",
            "Ouvert",
            "En attente"
        }
    )
)

         


        Regards,

        Harsh Nathani


        Appreciate with a Kudos!! (Click the Thumbs Up Button)

        Did I answer your question? Mark my post as a solution!