Forum Discussion

James__'s avatar
James__
Helper I
1 year ago
Solved

Issue Managing Two Fact Tables

Hi,   I have two fact tables; one for insurance product sales, and the other for claims. I also have two separate DIM tables, which are Calendar and Dealer.   I need to identify which product sal...
Need Help
  • johnt75's avatar
    johnt75
    1 year ago

    One option would be to add a calculated column to the sales table, e.g.

    Claim made =
Sales[Sale ID] IN VALUES ( Claims[Sale ID] )
Idrissshatila's avatar
Idrissshatila
Super User
1 year ago

Hello James__ ,

 

then add the columns that are common between both as dims so you can filter both.

  • James__'s avatar
    James__
    Helper I
    1 year ago

    then add the columns that are common between both as dims so you can filter both.
    Is there some text missing Idrissshatila