Forum Discussion
data model relationships not working
Hi I have built relationships between my data tabel in power pivot. I have tried to avoid many to many relationships by connecting everything to a unique look up value table. All relationshsips say...
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.
zedders1250 True, Power BI is more flexible in that respect!
- yes i think thats. Frustrating as power bi has an option to filter in both direction on their data model. TThanks for you r help