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 ,

 

without a model with sample data, it's almost impossible to provide guidance.

 

But one thing you must check is this, make sure that the table visual is using columns from the dimension tables. I consider it not surprising if add columns from the many side of a relationship to a table visual that the number of the rows is growing.

 

I'm sorry that I can not provide more help.

 

Regards,

Tom