How to get the distinctcount of matching entries in the related table

[thomasreick]

Hi there,

I am actually stuck on this.

fact and dim-Tabel are related using the field productcode.

Because the dim is not in a DWH but an external file there is a mistach in the count of productcodes.

The dim holds many more productcodes (~ 5.000) than the fact is providing.

NoOfFactProductCodes = DISTINCTCOUNT(fact[Produkcode)] =650

How do I generate a measure to count the related productcodes that are matching within my dim (DISTINCCOUNT of INNER JOINed) Fields.

Thanks for input.

Thomas

[thomasreick]

Hello johnT75,

Perfect, thank you very much. This is working and gets me the desired value.

Thomas

[johnt75 · Accepted solution]

Try 

Num matched product codes =
CALCULATE (
    DISTINCTCOUNT ( fact[product code] ),
    NOT ISBLANK ( dim[product code] )
)