Forum Discussion
Inactive Relationshhip Just Slicer
Hi,
Could somebody please help me in the simple example that ive attached?
I need to make my relationship with stock and sales to the country active, but I have multiple measures in my actual sheet. I know that you can use userelationship on a measure by measure basis, but does this mean it has to be used on every measure on the page to work with the slicer?
In the attached I need the country table to work and slice both tables, even though they already both use the item table in a bi directional way.
Thanks
Liam
Change your data model slightly
6 Replies
- lbendlin
Super User
Change your data model slightly
- lherbert501
Post Prodigy
Hi lbendlin ,
Thankyou for this. If I was to include a date table in the same way the country table operates, would this slot in exactly the same?
Thanks
Liam
- lbendlin
Super User
Yes, the date table is a dimension that controls both fact tables.