How to link when two columns dont match

[AwasthiAyush]

Hi All,

I have Customers in table 1 and table 2 and they are linked. Some of customers are not in table 2 so the ones which dont match, I am getting filter as blank. However I want Blank to be shown as Other in cat 2 . How do I get other instead of Blank. 

[Alex87]

I does not help me seeing your model. Please provide dummy data if you need additional help. 

[Alex87]

Hello,

you have a referential integrity problem in your model. That generated the blank row. You need to create a dimension that takes both the vales from table 1 and table 2 in Power Query. 

If my reply is not clear enough, please provide a sample data for table 1, table 2 and the relationship between the two.

[AwasthiAyush]

Hi, Please see the relationship and data