Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Measure check if have one related insuranse


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!

Community Champion
Community Champion

Hi @martin900 


Can you provide a usable data sample and expected outcome.



Best Regards,

Please feel free to connect with me.
Mariusz Repczynski




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). 



Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors