Select col1,'EOI' as col4,col2  from (
Select 'EOI' as col1,count(drmca_epcsubcontdtls_fk) as col2 from drmaincontanalytics_tbl where drmca_l1evnttype=1
union
select 'EOI' as col1,count( drsubcontanalytics_pk) as col2 from drsubcontanalytics_tbl where drsca_l2evnttyp=1
)

MEOI_TENDSTATUS =
VAR X1 =
CALCULATE (
    DISTINCTCOUNT ( drmaincontanalytics_tbl[drmca_epcsubcontdtls_fk] ),
    drmaincontanalytics_tbl[drmca_l1evnttype] = 1,
    drmaincontanalytics_tbl[drmca_tendstatus] = 5
)
VAR X2 =
CALCULATE (
    DISTINCTCOUNT ( drsubcontanalytics_tbl[drsca_epcsubcontdtls_fk] ),
    drsubcontanalytics_tbl[drsca_l2evnttyp] = 1,
    drsubcontanalytics_tbl[drsca_tendstatus] = 5
)
RETURN
X1 + X2