Forum Discussion

a4apple's avatar
a4apple
Icon for Helper I rankHelper I
9 years ago

How to create a measure from two different tables?

Please see my scenario below.

 

I have three tables. One a Dimension Table and two other fact tables. I have one measure in each of the Fact Tables and they join to the dimension by a key. Now I want to create a 3rd measure which is nothing but New Measure = DIVIDE([Count from Fact table 1], [Count from Fact table2], 0).

How to acheive this? Any ideas will be helpful.

Need Help

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Basic syntax should be:

     

    New Measure = DIVIDE(COUNTROWS('Table1'), COUNTROWS('Table2'),0)

    If you are trying to count rows in fact tables 1 and 2. If that is not what you are trying to do and [Count from Fact table1] and [Count from Fact table2] are the measures you reference, then your formula should work just fine. Then again, I may have completely misunderstood what you are going for here.