Forum Discussion

Narender's avatar
Narender
Resolver I
8 years ago
Solved

How to count distinct values ?

Hi All,   I want to calculate distinct count of my column in measure.   like:   Measure 2 = DISTINCTCOUNT((TAX_TRANSACTION[TAX_PAYER_NO])) This showing wrong result as i compared with my sql q...
Need Help
  • Narender's avatar
    Narender
    8 years ago

    Hi All,

     I got the reason of wrong value.

     

    Measure 2 = DISTINCTCOUNT((TAX_TRANSACTION[TAX_PAYER_NO]))

     

    I was using 2 square brackets'(('  but I have to use 1 square bracket '('

     

     

     

    Measure 2 = DISTINCTCOUNT(TAX_TRANSACTION[TAX_PAYER_NO]).

     

    :)

     

    Thanks everyone.

     

    Narender

Narender's avatar
Narender
Resolver I
8 years ago

Hi All,

 I got the reason of wrong value.

 

Measure 2 = DISTINCTCOUNT((TAX_TRANSACTION[TAX_PAYER_NO]))

 

I was using 2 square brackets'(('  but I have to use 1 square bracket '('

 

 

 

Measure 2 = DISTINCTCOUNT(TAX_TRANSACTION[TAX_PAYER_NO]).

 

:)

 

Thanks everyone.

 

Narender

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

Narender,

 

By the way, you may help accept the solution above. Your contribution is highly appreciated.