Card visual with number of non-matches from related table

[CoTheiss]

I do have two tables Products and ProductGroup that are related to each other via the field GroupID.

Now I want to create a Card that shows the number of ProductGroups that have no Products inside.

But as the ProductGroup table knows all contracts but not the No. of products assigned - and the products table knows all products and their assigned product groups but not those groups that have no assignment, I am a little bit lost here 🙂 

Products

ProductID

GroupID

ProductGroup

GroupID

Name

I guess this one is super easy, but still I dont know how to achieve it.

Any advice? 

[CoTheiss]

thank you so much @amitchandak ! 
That worked - definitely would not have come to that solution by experimenting on my own. 

Much appreciated

[amitchandak · Accepted solution]

@CoTheiss ,

countx(except(distinct(Productgroup[groupid]), distinct(Products[groupid]) ) , [groupid])