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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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