blank row

[pani_victoria]

Good afternoon, colleagues!

I would like to combine column values from 3 tables into a separate table.
I use

Counterparties =
var A01 = ALLNOBLANKROW('Receipts'[Counterparty])
var A02 = ALLNOBLANKROW('Payment orders'[Counterparty])
var A03 = ALLNOBLANKROW('Accounting for responsible persons'[Counterparty])
VAR partners = DISTINCT(UNION(A01, A02, A03))
return
partners

The output I get is the values + an empty string.
I don't understand why it appears if I use ALLNOBLANKROW. How to remove it?

[Ahmedx · Accepted solution]

pls try this

Counterparties =
var A01 = ALLNOBLANKROW('Receipts'[Counterparty])
var A02 = ALLNOBLANKROW('Payment orders'[Counterparty])
var A03 = ALLNOBLANKROW('Accounting for responsible persons'[Counterparty])
VAR partners = DISTINCT(FILTER(UNION(A01, A02, A03),[Counterparty]<> BLANK()))
return
partners

[pani_victoria]

But could you explain why it doesn't work ALLNOBLANKROW?

[pani_victoria]

Thanks a lot! It works!!! 😄