Forum Discussion
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’...
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.
HI koorosh ,
I would change the structure of your tables and have a User table which is a combination of UserPhoneNumber and User, and then just use this dimension as your slicer. This will then show each phone by user.
Understand star schema and the importance for Power BI - Power BI | Microsoft Learn this will help you to see what is needed in a star schema to get you going.