Forum Discussion
Create a Relationship Error
- Anonymous1 year ago
Thanks for az38's concern about this issue.
Hi, guybrit
I am glad to help you.
According to the problem you described, first you need to connect Power BI to different data source and then open Power Query Editor:
Select one of the tables and click Append Queries as New, then select the corresponding two tables and you will get a new table:
Ctrl+click Base Points and Bonus Points, right click and select Replace value, replace null with 0:
Close&Reply.
New measure in the new table:Total Points(Base + Bonus) = SUMX ( AppendTable, AppendTable[Base Points] + AppendTable[Bonus Points] )I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi guybrit
you should create first dimension table Buyers that consists only of Buyer names from both columns. distinct from union of two tables.
then connect this dimension table to 2 data sources
it is difficult to provide more detailed answer without your data model details