The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to 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!
Your picture joins StudentID ?
You can consume inactive relationships via measures and USERELATIONSHIP
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!
User | Count |
---|---|
27 | |
10 | |
8 | |
7 | |
5 |
User | Count |
---|---|
33 | |
14 | |
11 | |
10 | |
8 |