Returning blank rows when a specific column is used

Question

I seem to be having some issues with my data model as it is bringing back blank rows meaning that the relationship is invalid, so it is showing the rows that don't basically exist or cannot be matched.

With Branch Type Column

Without Branch Type Column

Data Model:

I know the main culprit has to be the data model but is there a way temporarily to actually not show those rows which dont have data?

Answer 1

I figured out how to solve my issue, I instead right clicked on the column and unticked show items with no data