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!

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!