Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I have a problem on establishing a relation between two tables. I have understood how to link two tables with unique values, but here I want to link two table only to be able to apply a filter on the whole report.
This will explain better the issue :
I have table A with 10 columns (number of client, 10 distincts numbers)(type of client, 2 distinct numbers)(etc.. etc..)
And table B with 10 columns (number of client, 10 distinct numbers)(type of client, 2 distinct numbers)(etc.. etc..)
I have visuals which come from both tables, and I'd like to be able to filter data in the visuals from the different types of clients (1st type or 2nd type)
How could I succeed in doing that ? Knowing that both tables contains like three thousand lines each, so I can't have link those as I don't have unique values.
Thanks already, I feel like the problem is easy but I can't find the path..
Solved! Go to Solution.
Hi @Joak,
Are the Client Types the same in both tables?
If so, try this:
Create a new table using the SUMMARIZE function, e.g.
SUMMARIZE ( Table A, [ClientType] )
This will give you a table with unique values for ClientType, which you can use to filter both original tables.
This is a brief description, let me know if you have difficulties.
Create a third table of unique client id's and relate it to both tables.
Create a third table of unique client id's and relate it to both tables.
thank you both it works 🙂
Hi @Joak,
Are the Client Types the same in both tables?
If so, try this:
Create a new table using the SUMMARIZE function, e.g.
SUMMARIZE ( Table A, [ClientType] )
This will give you a table with unique values for ClientType, which you can use to filter both original tables.
This is a brief description, let me know if you have difficulties.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |