Count Distinct from different tables + Find matching values

Hi trdoan,

Create the following measures:

Distintc Count Laboratory =
IF (
    DISTINCTCOUNT ( NDT[Store] ) = BLANK ();
    0;
    DISTINCTCOUNT ( Laboratory[Store] )
) + 0



Distintc Count NDT =
IF (
    DISTINCTCOUNT ( Laboratory[Store] ) = BLANK ();
    0;
    DISTINCTCOUNT ( NDT[Store] )
) + 0



NDT Alternatives Count =
IF (
    CALCULATE ( COUNT ( NDT[NDT] ); ALLSELECTED ( NDT[NDT] ) ) <> 1;
    DISTINCTCOUNT ( NDT[Store] )
)



NDT No alternatives =
IF (
    CALCULATE ( COUNT ( NDT[NDT] ); ALLSELECTED ( NDT[NDT] ) ) = 1;
    "No alternate Store can do : "
        & CONCATENATEX ( NDT; SELECTEDVALUE ( NDT[NDT] ); "," );
    "Alternative Stores: " & CONCATENATEX ( NDT; NDT[Store]; "," )
)

Check PBIX file attach.

Regards,

MFelix