Why do I see missing data in linked table

[Anonymous]

This is probably a very rudimentary database type of question: 

In these table attached, could someone please help and explain why do I see blanks in the joined table, in the "Zeta" column"?  

Thanks for your help!

[edhans]

When I set that data up in my PBI desktop, my table visual only shows IDs 2 and 3. 

1 and 4 are hidden from the Table A as there are no related records in table B to show. That happens as soon as I put in the Description column, which is what I would expect.

[Anonymous]

I selected "Show items with no data", after doing so, you should see what I see from my screenshots.

shouldn't I expect to see "B" in Zeta column for ID 1 in the join table?

[edhans]

Ok. then it works for me. I don't see the blanks.

Maybe share a link to the PBIX file?

[Anonymous]

What am I doing wrong?

[edhans]

I don't know. That is why I asked to see your PBIX file. There is somethign going on below the images that I cannot see.

[Anonymous]

I have attached a link to the .pbix file for download.  Link expiring March 10.

Thanks!

http://sendanywhe.re/X5Z7E2VR

[edhans]

I honestly don't know why it is doing that. If I uncheck "Description" and re-check it, it works fine - Zeta fills in. I can repro if I remove Description and Zeta, then add Description, then Zeta. But if I uncheck and recheck Description, it works.

On the surface this seems like a bug. I cannot imagine what quirk exists in DAX where the order you add columns to a visual will change the results.