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.

 

  • koorosh's avatar
    koorosh
    Post Partisan
    3 years ago

    Thanks. But I can not understand. Could you please explain when the slicer includes email addresses from the 'users' table, what does SELECTEDVALUE(Phones[PhoneNumber]) select when we choose one email address in the slicer?
    Please check the attached image.

    • johnt75's avatar
      johnt75
      Super User
      3 years ago

      When you put the phone number in a visual with this measure as a filter SELECTEDVALUE will refer to the phone number on the current row of the visual. The measure will then determine whether to show that row or not.