'New Column in report view NOT returning correct value

My data is a list of incoming deliveries from different cities.[Incoming]

My reference table has a list of Bays allocated to different cities.[Bay Allocation]

Many to one relationship.

My report has a list of the cities and the relevant Bay.

In report view I want add an extra column that puts "Not Allocated" where there is a blank bay.

Column = IF('Bay Allocation'[Bay]="","No Allocation",'Bay Allocation'[Bay])

However it is only returning a result where the Bay number already exists.

Is there a way of doing this or do I need to merge queries and do it that way?

Thanks for your patience and time in advance.

Solution 1:^[1]

You can't consider a "blank" field as "". Try something like this:

IF(ISBLANK('Bay Allocation'[Bay]),"No Allocation",'Bay Allocation'[Bay])

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	DC-A