Forum Discussion
Beneficiary Model - Fact Table Does Not Properly Filter Beneficiary Table
Hey WinterMist ,
regarding
1) use CROSSFILTER( ..., ..., BOTH) to create a dedicated measure instead of changing the cross-filter direction2) 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
1) So the bi-directional relationship does fix the issue. However, I am one of those people who typically runs into other adverse problems caused from using bidirectional; and I later have to remove it. So although I will mark this as a solution, doing this gives me a great deal of uneasiness. (If there was a way to resolve this via the measure, I would much prefer doing it that way.)
2) I added your book recommendation to my Amazon list. Thanks for that.
3) I am most intrigued by your comment on how measures create relationships that do not exist within our models. Specifically, you wrote that my measure is creating a relationship between:
"Insured 1" and beneficiary "Sid" via the bond of "Corn" (Fact Policy Key 17).
Would you be able to educate me any further on how this is happening?
I believe you; but when I look at the Fact table, this makes no sense to me at all.
"Insured 1" should not connect with Fact Policy Key 17 at all.
Definitely not understanding how the measure is causing Insured 1 to form a relationship with ALL beneficiaries.
Is there a way for me to write the measure differently to prevent this?
Regards,
Nathan
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
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