topic Slicer for Active and Inactive relationship in DAX Commands and Tips

Slicer for Active and Inactive relationship

ryand009 — Tue, 02 Apr 2024 16:15:55 GMT

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

Re: Slicer for Active and Inactive relationship

StrategicSavvy — Tue, 02 Apr 2024 21:14:17 GMT

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!

Re: Slicer for Active and Inactive relationship

lbendlin — Tue, 02 Apr 2024 21:32:51 GMT

Your picture joins StudentID ?

You can consume inactive relationships via measures and USERELATIONSHIP