Slicer for Active and Inactive relationship

[ryand009]

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??

Thanks in advance

Roy

[lbendlin]

Your picture joins StudentID ?

You can consume inactive relationships via measures and USERELATIONSHIP

[StrategicSavvy · Accepted solution]

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!