Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |