Forum Discussion
data model relationships not working
zedders1250 Difficult to answer if you don't tell what your are doing, but it seems you are counting BP's from the dimension table based on a column from one of the fact tables. Then you are filtering against the direction of the relationship. It will work, however, when you either put the BP in the Row or Column field.
Since you didn't share any data to work with, I made a mock-up to demonstrate. See attached.
Unfrtunatly i cant share the data due to data protect but ive created an example and attached . I know what you mean about the flow of the relationship but i cant change the direction of the reltion as there duplcate values in the other table. The example i've attached is very simplistic but in my real world use case there are 27k BPs and it isnt possble for me to put then in the rows. I just wanted to show how many unique accounts from the look up table had had some sort of contact or didnt show in contact data
Riny_van_Eekelen seems im unable to upload a speadsheet in the same way that you have
zedders1250 Attached my mock-up again with a measure called BPcount using CROSSFILTER that allows you to filter from the many-side to the one-side using BP from the dimension table. I believe that's what you need.