UNION distinct no blank column cells between 2 Tables

[rmeng]

Hello,

I have 2 tables and I want the distinct count of HCP_MDM_ID from both.

I´m using the following measure
#ReachUnion =
COUNTROWS (
             DISTINCT (
                      UNION (
                             VALUES ( EVENTS[HCP_MDM_ID] ),
                             VALUES ( INTERACTIONS[HCP_MDM_ID] )
                       )
               )
 )

However it´s counting the blank  HCP_MDM_ID too and I only want with No Blanks()

Can you help me please 

[Greg_Deckler · Accepted solution]

@rmeng Try:

#ReachUnion =
COUNTROWS (
     FILTER(
             DISTINCT (
                      UNION (
                             VALUES ( EVENTS[HCP_MDM_ID] ),
                             VALUES ( INTERACTIONS[HCP_MDM_ID] )
                       )
               ),
     [HCP_MDM_ID] <> BLANK()
     )
 )

or try this:
#ReachUnion =
COUNTROWS (
             DISTINCT (
                      UNION (
                             DISTINCT( EVENTS[HCP_MDM_ID] ),
                             DISTINCT( INTERACTIONS[HCP_MDM_ID] )
                       )
               )
 )

[rmeng]

SOLUTION FOUND THANKS