Forum Discussion

Narender's avatar
Narender
Icon for Resolver I rankResolver 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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Narender,

Do you have blank values in the column?  Those have an effect on the output and might be the reason for the difference...

 

 

 

 

 

 

Br,

T