check dax

[ayoubb]

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é]

[parry2k]

@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]

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 · Accepted solution]

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.