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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
ryand009
Frequent Visitor

Slicer for Active and Inactive relationship

Hello

I've got the following Active and Inactive relationship between 2 tables. Is there a way to  create slicers that display StudentName for Proposer1 and Proposer2?

 

I've tried using SelectedValue, but can't get it to work, I've als seen a thread from 2020 suggesting 2 tblStudents, but this seems on the heavy side, is there an easier soluion??

 

ryand009_0-1712073729674.png

Thanks in advance

Roy

 

 

1 ACCEPTED SOLUTION
StrategicSavvy
Resolver II
Resolver II

hi @ryand009 

 

How about this:

1. Measure on active relationship

Measure 1 = MAX('tblProposals'[Proposer1])

 

2 Measure on inactive relationship:

Measure 2 = CALCULATE(
                MAX('tblProposals'[Proposer2]),
                USERELATIONSHIP('tblStudents'[StudentID], 'tblProposals'[Proposer2])
               )

 

 

Hope it helps!

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

Your picture joins StudentID ?

 

You can consume inactive relationships via measures and USERELATIONSHIP

StrategicSavvy
Resolver II
Resolver II

hi @ryand009 

 

How about this:

1. Measure on active relationship

Measure 1 = MAX('tblProposals'[Proposer1])

 

2 Measure on inactive relationship:

Measure 2 = CALCULATE(
                MAX('tblProposals'[Proposer2]),
                USERELATIONSHIP('tblStudents'[StudentID], 'tblProposals'[Proposer2])
               )

 

 

Hope it helps!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.