Forum Discussion

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

Unique values in each table

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 ...
  • Irwan's avatar
    Irwan
    1 year ago

    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.

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
1 year ago

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

  • Irwan's avatar
    Irwan
    Icon for Super User rankSuper User
    1 year ago

    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.