How to show values that do not match values from a different column?

[Anonymous]

I have two columns: branches and orders. 

Some of the orders correspond to certain branches. However, several branches do not have orders. 

How can I show the branches with no orders?

[miltenburger]

Don't know the exact tableheaders you have,

But has something to do with where orders = 'NULL' 

[Anonymous]

Unfortunatelly, 'Orders' do not have 'null' values, just order numbers. 

[miltenburger]

Can you show me the table in an image with records in it?

[Anonymous]

[Anonymous]

These branches have orders.

And I have to find branches with no orders if there are such.

[v-huizhn-msft]

Hi @Anonymous,

As you said, 'Orders' do not have 'null' values, just order numbers. But how to judge branches with no orders? Could you please share the rules?

Best Regards,
Angelia

[Anonymous]

@v-huizhn-msft, that's the thing. I do not how to distinguish such kind of orders as there are no criteria

Say, you have two data sets:

Branch  OrderID

A           1

B           

C           3

D           4

Power BI will show it this way:

Branch  OrderID

A           1 

C           3

D           4

'How to find branch 'B'?' is the question.

[v-huizhn-msft · Accepted solution]

Hi @Anonymous，

As I tested, I create sample table as yours.



When I create a table visual to display the data, it still can shows the rows where OrderID is blank as follows. How can you get the second table you posted? 



Please try to trun on the "Show items with no data" and check if it works fine.

Best Regards,
Angelia

[Anonymous]

Thank you. That helped much.