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.

     

DemoFour's avatar
DemoFour
Continued Contributor
3 years ago

koorosh 

If you structure the model to have all information on the user, phone number and email in a table with a key, then this is your customer dimension.  Once you have this joined the the fact table about Phones, your output will work. 

The relationship will be a 1 to Many with much more data and proper keys, as currently there is a 1 - 1 relationship with the source test data.  You will then be able to filter your fact by the dimension. 




 

Your DAX will also be much simpler in writing with this type of model, other wise you are just building up technical debt!