Measure check if have one related insuranse

[martin900]

Hi

I have a one to many relationship. One customer can have many insurances. I want to create a measure that counts all all customers that have insurance (one or more). I also want to create a measure that counts all customers that have one insureance, all customers that have two, and so on. How can I make this measure? Thanks for any help!

[Mariusz]

Hi @martin900 

Can you provide a usable data sample and expected outcome.

Best Regards,
Mariusz

Please feel free to connect with me.

[martin900]

Hi

I uploaded a picture of the datamodel-

If I count all customers on contactid I get 1200. If I count all insurance I get 900. But one customer can have more than one insurance so it will be fewer then 900 contacts with insurance. My outcome will be to find out how many customers have insurance (one or more).