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...
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!

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!

     

     

    • ayoubb's avatar
      ayoubb
      Helper IV
      6 years ago

      Thank you Nathani for your help, 

       

      Please i want to add in the same filter another one, which to countrows all "statut demande de service" except "En cours" and "Ouvert" and "En attente" for only these agents "A" and "B" and "C" in a different column's name "AGENT"

       

      Thank you for your help,

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        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!