Forum Discussion

ayoubb's avatar
ayoubb
Helper IV
6 years ago
Solved

double request number

i have a data base that contains a lot of ticket numbers with different status, i want to calculate these tickets numbers without counting the double tickets , here is below a screen capture to under...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi ayoubb ,

     

    Try this measure:

    Measure = CALCULATE(DISTINCTCOUNT('Table'[N° demande de service]),ALLSELECTED('Table'))

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ayoubb's avatar
ayoubb
Helper IV
6 years ago

Thank you for your reply, however i tried the DAX that you provided me but shows me wrong data, 

 

you see the table below, in the column "N° demande de service" i have tickets numbers which they're dublicated, i want a formula that count dublicated ticket for one time.

 

for example this column N° demande de service, if i calculate the ticket number the result should be: 3

 

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi ayoubb ,

 

Try this measure:

Measure = CALCULATE(DISTINCTCOUNT('Table'[N° demande de service]),ALLSELECTED('Table'))

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.