Forum Discussion

mikeng's avatar
mikeng
Frequent Visitor
8 years ago
Solved

calculation using 2 fact tables

Hi guys, I'm struggling for days on this problem. So I have 2 fact tables (assume that they are linked by all necessary Dimension tables): Table A: which contains value (USD) Table B: allocation ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may download my PBI file from here.

     

    Hope this helps.

     

WolfBiber's avatar
WolfBiber
Microsoft Employee
8 years ago

Hi mikeng, if you have already a connection in your Datamodel use Following Dax using a 'New Measure':

Allocation = sum(TableA[USD]) * max(TableB[Allocation rate])

Greetings

  • mikeng's avatar
    mikeng
    Frequent Visitor
    8 years ago

    Thanks for your suggestion. I've tested it and it doesn't work.