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 SelectedV...
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!

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