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.

v-hashadapu's avatar
v-hashadapu
Icon for Community Support rankCommunity Support
1 year ago

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.