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

kaushikd's avatar
kaushikd
Icon for Resolver II rankResolver II
8 years ago

Hi

 

DISTINCTCOUNT() is the exact dax function for the scenario you explained, may be you are doing something wrong in either modelling.

 

walk through the example to have a brief idea about the result returned by DISTINCTCOUNT().

https://msdn.microsoft.com/en-us/query-bi/dax/distinctcount-function-dax

 

 

If still you face problem please attach the file or share it, we will look into the scenario.