Aug 26 2021 09:27 AM
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 relation from unique customer ids to duplicate customer ids, then when i did the pivot table by using data model,
i used the customer ids from unique table & customer preferences from customer_preference table which contains duplicate ids, but it gave wrong results dont know why
Aug 26 2021 12:41 PM
SolutionIf you have nothing in Values, PivotTable performs Full Outer join, i.e. all to all. As soon as you add any value relationships work.
Sep 04 2021 12:00 PM
@chahine , you are welcome
Nov 18 2022 09:57 AM
@Sergei Baklan - what if I do not have values in my tables?
Nov 18 2022 12:06 PM
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.
Nov 01 2023 12:17 AM
Dec 04 2023 07:40 PM
@Sergei Baklan Hi, I have got the same situation and try to put some count as you have suggested but it still does not work. Do you know how can we handle this? Thanks you.
Dec 10 2023 09:51 PM
Aug 26 2021 12:41 PM
SolutionIf you have nothing in Values, PivotTable performs Full Outer join, i.e. all to all. As soon as you add any value relationships work.