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

Thejeswar's avatar
Thejeswar
Super User
8 years ago

Hi,

Your DAX staement is correct. Ideally it should show the right values