Forum Discussion

captainlaw's avatar
captainlaw
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago
Solved

join not working

Hello, I'm not able to get the JOIN to work in Power BI Desktop.  Is supposed to join on Country, but when I select Country, it only returns Age, not 2014 measure.  See above images.    ...
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    Ok. You have a empty space before the country in the table. "Cambodia" " Cambodia"

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
10 years ago

hi captainlaw this is your relationship?

 

  • captainlaw's avatar
    captainlaw
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    I copied the relationship previously.  Here's another look from diagram perspective.

    • Vvelarde's avatar
      Vvelarde
      Icon for Community Champion rankCommunity Champion
      10 years ago

      Do you have a slicer that maybe is filtering something?

      • captainlaw's avatar
        captainlaw
        Icon for Microsoft Employee rankMicrosoft Employee
        10 years ago

        No slicer... straight from the table.