One Sum Calculation not working for one dimension

[crisher]

I have a very legacy model that is far from ideal, but we are re-working all of our models with a new general ledger. However, until we have removed all the technical debt, I need to figure out why this one Sum is not working. Instead of trying to type out all of the details, this video URL below will explain the problems.

https://drive.google.com/file/d/1ZHSKdjZwFj9tIcOLbEoGBI90-kfb21_R/view?usp=drivesdk

I just need to get the LY T&E to work for all customers regardless of where I pull that from. The calculation, as you can see in the video above, is very basic. Clearly, this is some relationship issue.

[crisher]

While I appreciate and understand your response, I have inherited this model and am trying to troubleshoot something for a last-minute business meeting. I do agree that this issue is likely the result of the overall model being a problem.

[Anonymous]

Thanks for the reply from danextian. 

Hi @crisher ,

If Danextian's reply is helpful to you, could you please accept it as a solution? This will help other community members who are experiencing similar problems to solve them faster. Thank you very much for your cooperation! Please feel free to let us know if you have any other questions.

Best Regards,
Zhu

[danextian]

I can see that your legacy model is seriously very far from ideal. Other than many-to-many, I can see a lot of bidirectional relationships which themselves can cause unexpected results. If I were in your shoes, I would just start rebuilding this model - I'd combine tables with the same structures into one, use a separate dates table (like you mentioned in the video), use dim tables to bridge the fact tables with different structures.