I’m pulling my hair out! Can you take a look at the attached sample and help me (please) understand why average age is not calculating at the product level. The age is the same number. In my model, I have a one household code (customer) to many household codes (customers) relationships. I could ch…

Hi @rizzotony You are using sum on the age detail in the sales table [image] I’m not sure why you would sum the detail information. If you use the Proddesc in the Demographic and ave age calculation(comes from Demographic table) in the key measure table then i think you will get the right answe…

One to many relationship

Power BI Data Model

DavieJoe July 17, 2021, 8:06am 4

Hey @rizzotony, hope you’re well

@BrianJ shared this book recommendation yesterday, which I’ll also buy shortly too.

1 Like