Forum Discussion

chahine's avatar
chahine
Iron Contributor
Aug 26, 2021
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...
BI & Data Analysis
excel
power bi
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 26, 2021

    chahine 

    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's avatar
SergeiBaklan
Diamond Contributor
Aug 26, 2021

chahine 

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.

  • MarkusK's avatar
    MarkusK
    Copper Contributor
    Nov 01, 2023
    Your tip made my day! Thanks so much Sergei!
    • Chichi475's avatar
      Chichi475
      Copper Contributor
      Dec 05, 2023

      SergeiBaklan 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.

       

      • Mdataguy's avatar
        Mdataguy
        Copper Contributor
        Dec 11, 2023
        Thanks everyone, all very helpful.
        Chichi475 I was facing the same issue.
        The problem for me was I was trying to add values from the secondary table not the primary table that was linked to the pivot table. As soon as I added a value from the primary table to values it worked fine.
  • grsur's avatar
    grsur
    Copper Contributor
    Nov 18, 2022

    SergeiBaklan  - what if I do not have values in my tables?

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 18, 2022

      grsur 

      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. 

       

  • chahine's avatar
    chahine
    Iron Contributor
    Sep 04, 2021
    Thanks !

Resources