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!

StrategicSavvy's avatar
StrategicSavvy
Resolver 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!