Forum Discussion

ayoubb's avatar
ayoubb
Helper IV
6 years ago
Solved

check dax

Hello , could you please check for me this DAX

 

résolu test = CALCULATE(
DISTINCTCOUNT('Sheet1'[N° demande de service]),
'Sheet1'[Statut] IN {"RESOLU", "CLOTURE"}
'Sheet1'[Groupe Historisé] IN {"SAF","SAF_N1","SAF_N0"},
)
 
I want to distinctcount 'Sheet1'[N° demande de service] and cound how many 'Sheet1'[Statut] IN {"RESOLU", "CLOTURE"} for these groupes {"SAF","SAF_N1","SAF_N0"} which they exist in other column's name {groupe historisé]
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi ayoubb 

    Create a measure

    Measure = CALCULATE(DISTINCTCOUNT('Table'[service]),FILTER('Table','Table'[status]="r"&&'Table'[group] in {"n1","n2"}))

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    ayoubb yes it looks correct.  Are you not getting correct value?

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

     

     

    • ayoubb's avatar
      ayoubb
      Helper IV
      6 years ago

      I"m not getting nothing, 

       

      THIS IS WHAT I WANT BELOW

       

      RESOLU=

      CALCULATE(

          DISTINCTCOUNT('Statut des DS'[No demande de service]),

           'Statut des DS'[Statut] = "RESOLU" IN 'statut des DS'[Groupe historisé]=N1 & N2

       

      the result should be: 2

       

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        6 years ago

        Hi ayoubb 

        Create a measure

        Measure = CALCULATE(DISTINCTCOUNT('Table'[service]),FILTER('Table','Table'[status]="r"&&'Table'[group] in {"n1","n2"}))

        Best Regards
        Maggie
        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.