Forum Discussion

nvizard's avatar
nvizard
Regular Visitor
6 years ago
Solved

Count distinct values across two separate rows in two separate tables

Hi all, I am trying to count the number of distinct values that occur in two separate columns in two separate tables (count the number of distinct values as though the two columns were appended)  F...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    nvizard 

     

    You may try the measure below.

    Measure =
COUNTROWS (
    DISTINCT ( UNION ( VALUES ( Table1[Column1] ), VALUES ( Table2[Column1] ) ) )
)

     

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
6 years ago

nvizard 

 

You may try the measure below.

Measure =
COUNTROWS (
    DISTINCT ( UNION ( VALUES ( Table1[Column1] ), VALUES ( Table2[Column1] ) ) )
)