Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Solved! Go to Solution.
Hi @prakash11440278,
In order to create this visualisation now you should use the "customer" field from the new table you created.
Best,
Kris
Hi @prakash11440278,
In order to create your relationship you should first create a table that contains all the unique values from the columns that you wish to create the relationship on. I've assumed both tables have a column called Customer. Create a new Table using the measure
Customers = DISTINCT(UNION
(SELECTCOLUMNS(Table1,"Customer",[Customer]),
SELECTCOLUMNS(Table2,"Customer",[Customer])))
This measure will create a union of the 2 customer columns and then remove all duplicates leaving you with all your distinct customers. You can then create a relationship in the relationship window as follows
Alternatively (this would be my prefered method), if you wished to do this in the query editor, you could append the 2 tables that you require to relate (as a new query) and keep only the column you wish to create a relationship on. A quick removal of duplicates and you have your distinct customer table. You can then create the relationship as above.
Hope this helps.
Regards,
Kris
Alternatively (this would be my prefered method), if you wished to do this in the query editor, you could append the 2 tables that you require to relate (as a new query) and keep only the column you wish to create a relationship on. A quick removal of duplicates and you have your distinct customer table. You can then create the relationship as above.
does not work i tried.
Harsha
Hi kriscoupe,
Thanks for your reply.
I created new a table, as suggested below. Still the issue remains same. Please find the attached screen shot.
Hi @prakash11440278,
In order to create this visualisation now you should use the "customer" field from the new table you created.
Best,
Kris
User | Count |
---|---|
75 | |
75 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |