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] )
v-sdhruv's avatar
v-sdhruv
Community Support
1 year ago

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.