Forum Discussion
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 sales have made a claim, and more importanty, which have not, using their reference number. However, i am aware that i shouldn't try and connect the two fact tables. Can anyone help?
Regards
J
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] )
6 Replies
then add the columns that are common between both as dims so you can filter both.
Is there some text missing Idrissshatila
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] )Thanks Idrissshatila and johnt75 for the helpful suggestions!
James__ — were you able to implement either of these approaches successfully?
Let us know if you need help setting up the shared dimension or writing the DAX expression.
