cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
martin900
Helper I
Helper I

Measure check if have one related insuranse

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!

2 REPLIES 2
Mariusz
Community Champion
Community Champion

Hi @martin900 

 

Can you provide a usable data sample and expected outcome.

 

 

Best Regards,
Mariusz

Please feel free to connect with me.
Mariusz Repczynski

 

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

 

insurance.png

Helpful resources

Announcements
Carousel_PBI_Wave1

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