Adding Relationship kills results, Why does this relationship break things?

[PhilSmith]

I have a table visual that pulls data from Budgets.  When I create a relationship to  Accounts, that visual goes blank.  It shouldn't.

There are perfect matches between the two columns being related.  They are the same data type.  If I create a calculated column to LOOKUPVALUE() the data exactly as the relationship would, it works fine.  If I use that calculated column in a relationship, it fails the same way.

I have trimmed this model down to just these two tables.  I have two inactive relationships, The one I want and the one based on the calculated column.  Making either one Active breaks the visual.

This seems to be a no brainer to me, this should just work.  Can someone tell me what I am missing here?

BrandDataDEVFORUM.pbix

Thanx

Phil

[PhilSmith]

Thank You.  I forgot we made some changes recently.  I apprecaite teh extra set of eyes.

Phil

[andrewsommer · Accepted solution]

The issue is not the relationship it is the filters you have set.  Your dataset does not contain any rows that have the combination of Account[account] in (8170,8175), Budget[budegt ID] = 13 and budget_name = 2025.

When I look at your data for rows for those accounts and those budget IDs all of the budget names are blank which is why your table is blank.

Please mark this post as solution if it helps you. Appreciate Kudos.