Forum Discussion
Related function returns unexpected results
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?To the left are things like Project Manager, Dept, Project # that I didn't think was relevent.
Majority of it is coming from "Flat CDTLaborView" with only whats necessary coming from "Financials".
Yep, I excluded the "flat" part for simplicity and didn't know it meant anything.So it is not columns except from the two tables in question.
I can't seem to reproduce the error.
Short of digging around in the pbix file myself, not sure what I can do. If you are inclide to post a link to a pbix file (idealy one that uses fake data, but still in the same format etc.) I would spend a little bit looking at it for you.