Forum Discussion

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

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