Forum Discussion

lherbert501's avatar
lherbert501
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

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?

 

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

6 Replies

  • Change your data model slightly

     

     

    • lherbert501's avatar
      lherbert501
      Icon for Post Prodigy rankPost 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's avatar
        lbendlin
        Icon for Super User rankSuper User

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