Forum Discussion
Solved
Data model relations not working properly in power pivot
Hi when doing relations i had some strange results, although same when i did in power bi it worked i have 2 tables of customers one with unique values & one with duplicates, so when i made the re...
If you have nothing in Values, PivotTable performs Full Outer join, i.e. all to all. As soon as you add any value relationships work.
SergeiBaklan - what if I do not have values in my tables?
Sorry, I didn't catch. If you don't have any values in your source tables you actually have no such tables, Values could be texts, whatever. In PivotTable you need to aggregate something to have proper result, e.g. count number of such texts.