Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
lherbert501
Helper V
Helper V

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

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Change your data model slightly

 

lbendlin_0-1697411460028.png

 

View solution in original post

6 REPLIES 6
lbendlin
Super User
Super User

Change your data model slightly

 

lbendlin_0-1697411460028.png

 

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

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

@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.

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.

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.