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

WinterMist's avatar
WinterMist
Impactful Individual
2 years ago

TomMartens 

 

Yes, that would be fine to use the sample PBIX in an article if you wish.

 

Thanks especially for the recommendation to use:

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

 

Thanks again for your time.

 

Regards,

Nathan