Forum Discussion

ryand009's avatar
ryand009
Frequent Visitor
2 years ago
Solved

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

 

Thanks in advance

Roy

 

 

DAX
  • StrategicSavvy's avatar
    StrategicSavvy
    2 years ago

    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!

2 Replies

  • StrategicSavvy's avatar
    StrategicSavvy
    Icon for Resolver II rankResolver II
    2 years ago

    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!

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Your picture joins StudentID ?

     

    You can consume inactive relationships via measures and USERELATIONSHIP