Inactive Relationshhip Just Slicer

[lherbert501]

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?

Dummy Data.pbix

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

[lbendlin · Accepted solution]

Change your data model slightly

[lherbert501]

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]

Yes, the date table is a dimension that controls both fact tables.

[lherbert501]

@lbendlin 

It doesn't seem to like it as I have to link via bridge table. Its creating many to many as date dimension has multiple entries for a period.

[lbendlin]

Make sure your fact tables have date columns. Create fake ones if needed. For example if your fact only has monthly granularity create a date column for the beginning of the month.

[lherbert501]

Thankyou so much for your time with this @lbendlin . It really is appreciated