cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver I

## 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 query result.

Without distinct is showing right result

COUNT((TAX_TRANSACTION[TAX_PAYER_NO])) is showing right result as i compared with my sql query result.

Please let me know, how can i write expression in dax for distinct count??

Thanks

Narender

1 ACCEPTED SOLUTION
Resolver I

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

5 REPLIES 5
Resolver I

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

Community Support

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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

Resolver II

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.

Resident Rockstar

Hi,

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.