Issue Managing Two Fact Tables

[James__]

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

[v-sdhruv]

Hi @James__ ,
Just wanted to check if you were able to resolve the issue.
If are still facing the problem, let us know and we would be happy to assist you further.
Thank you

[v-sdhruv]

Hi @James__ ,
Just wanted to check if you were able to resolve the issue.
Thank you

[v-sdhruv]

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.

[johnt75 · Accepted solution]

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]

Hello @James__ ,

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

[James__]

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