Forum Discussion
Related function returns unexpected results
Data-estDog The relationship is Many to One, CDTLaborView is many and Financials is One.
I am going to need more information/context here. A 1 to * type doesn't tell me much.
This post give some great tips on how to present your situation so we can best help: How to Get Your Question Answered Quickly - Microsoft Fabric Community
They are linked via WBSID which is a combination of the WBS# fields so we could create a relationship between the tables.
This is a very odd model. Financials appears to be a partial dimension linked to multiple fact tables. Actually this looks like there has been no modeling done, all the tables are flattend and linked with transactional source system keys. I am inclined to think the relationships are exploding the results somehow.
In your output example, what are the rest of the fields? What tables are they coming from?
Also, in your calculation you use: CDTLaborView[Total Hours]. Different than the "Flat CDTLaborView". Did you just simplify the table name for the example or is there another table somewhere?
