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.

az38's avatar
az38
Community Champion
6 years ago

Hi ayoubb 

you need smth like

Measure = DISTINCTCOUNT(Table[N demande])