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’[Title] one to many ‘Phones’[PhoneNumber]
I want a table visual including 3 columns from the Phones table (Phonenumber, Title, serialnumber) along with a slicer on the page including Useremail from the Users table so that this slicer can filter the table visual.
Solved! Go to Solution.
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!
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.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.