Forum Discussion

koorosh's avatar
koorosh
Post Partisan
3 years ago
Solved

Junction table

Hi, The tables in the attached file have the following relationships: ‘Users’[Useremail] one to many ‘Usersphoneumber’[Useremail] ‘Simcards’[Title] one to many ‘Usersphoneumber’[Title] ‘Simcards’...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    You can create a measure like

    Phone is visible = IF ( SELECTEDVALUE(Phones[PhoneNumber]) IN VALUES(UserPhoneNumber[PhoneNumber]), 1 )

    and use that as a visual level filter to only show when the value is 1.

     

johnt75's avatar
johnt75
Super User
3 years ago

You can create a measure like

Phone is visible = IF ( SELECTEDVALUE(Phones[PhoneNumber]) IN VALUES(UserPhoneNumber[PhoneNumber]), 1 )

and use that as a visual level filter to only show when the value is 1.