Forum Discussion

WinterMist's avatar
WinterMist
Impactful Individual
2 years ago
Solved

Beneficiary Model - Fact Table Does Not Properly Filter Beneficiary Table

Hello Community -   I have 2 models where the "Fact" table has a 1:* relationship with a "Beneficiary" table.   Each Policy ID should only appear in the Fact table once. However, a single Policy...
Need Help
  • TomMartens's avatar
    TomMartens
    2 years ago

    Hey WinterMist ,

     

    regarding
    1) use CROSSFILTER( ..., ..., BOTH) to create a dedicated measure instead of changing the cross-filter direction 

    2) I think it will be a great read

    3) I do not think I will spend this time to write about this type of relationships here, maybe I will write an article on my site. But, it is obvious (from my perspective) as the measure makes the second table "explode".

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Super User
2 years ago

Hey WinterMist ,

 

regarding
1) use CROSSFILTER( ..., ..., BOTH) to create a dedicated measure instead of changing the cross-filter direction 

2) I think it will be a great read

3) I do not think I will spend this time to write about this type of relationships here, maybe I will write an article on my site. But, it is obvious (from my perspective) as the measure makes the second table "explode".

 

Regards,

Tom

TomMartens's avatar
TomMartens
Super User
2 years ago

Hey WinterMist ,

 

can I use your sample pbix if I decide to write an article and publish the article on my website (minceddata.info) and will provide a download link to the pbix that points to my OneDrive, of course I will provide a link to this discussion and I will mention that the pbix was first published here?

 

Regards,

Tom