dax to calculate id with diff product

[Anonymous]

Hi 

Need help to calculate count of id with same ID no. but different product

for e.g.

Vendor ID	Product
1234	ABC
1234	DEF
1234	XYZ
345	GHJ
345	GHJ
6789	WER
8901	RTY
8901	ASD
8901	DFG

I have table like this. In this I want to count those vendor id which are getting repeated for different product. 

For e.g. 8901 and 1234 will be counted in the above case. 

Help mw with the dax function of it.

[AlB]

Hi @Anonymous 

Place this measure in a card visual:

Measure =
SUMX (
    DISTINCT ( Table1[Vendor ID] ),
    INT ( CALCULATE ( DISTINCTCOUNT ( Table1[Product] ) ) > 1 )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers