topic Re: Unique values in each table in DAX Commands and Tips

Unique values in each table

stribor45 — Sun, 20 Apr 2025 23:03:10 GMT

I am trying to find unique values in each tables. So for example get unique id's in table A and do the same for table B. Now I want to make sure when I count these ID's not to count them twice since same ids can be in each table. I know what I need to use base table for this code but cant sedem to understand how to resolve this. Can anyone assist please

DEFINE VAR A = VALUES('Table A'[ID]) VAR B = VALUES('Table B'[ID]) VAR C = UNION(A,B) VAR D = DISTINCTCOUNT(C[ID]) EVALUATE D

Re: Unique values in each table

Irwan — Sun, 20 Apr 2025 23:29:48 GMT

hello stribor45

please check if this accomodate your need.

i made a simple dataset.

based on above dataset, the distinct count should be 11.

i assumed you want to do this in measure, so create a new measure with following DAX.

Hope this will help.

Thank you.

Re: Unique values in each table

stribor45 — Sun, 20 Apr 2025 23:49:22 GMT

This works but how does the outer DISTINCT know that we are talkinjg about ID column? Is it because it is only one column?

Re: Unique values in each table

Irwan — Mon, 21 Apr 2025 00:37:49 GMT

hello stribor45

i might be misunderstood but you can target the value you want to calculate the distinct value.

otherwise, please share your sample dataset and your expected outcome.

Thank you.

Re: Unique values in each table

v-hashadapu — Fri, 25 Apr 2025 12:27:36 GMT

Hi stribor45 , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answers that helped 'Accept as Solution', so others with similar queries can find them easily. If not, please share the details.
Thank you.