Forum Discussion

jd8766's avatar
jd8766
Icon for Helper II rankHelper II
4 years ago
Solved

Dealing with multiple fact tables?

We have a star schema in place currently (see screenshot example), however I have been tasked to add a new Fact table (the payments one) into our existing SSAS model.   I am planning on using t...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi jd8766 ,

     

    You are right.

    If you want to avoid relationship, you will need to create a measure like below:

    Measure = CALCULATE(SUM('Fact Payment'[PaymentAmount]),FILTER('Fact Payment','Fact Payment'[ContractKey] in VALUES('Fact Sales'[ContractKey])))

     

    Best Regards,

    Jay