How to add one more SOURCE from my existing expression ?

[admin11]

Hi All

My below expression working for last 2 year :-

Source =

var _1=DISTINCT(UNION(all(SALES[SOURCE]), all(TARGET_[SOURCE])))

return

FILTER(_1,[SOURCE]<>BLANK())

To day i have Add new table = DO . So i need to modify the above expression to below :-

Source TEMP =

var _1=DISTINCT(UNION(all(SALES[SOURCE]),all(DO[SOURCE]), all(TARGET_[SOURCE])))

return

FILTER(_1,[SOURCE]<>BLANK())

I get erroe msg below :-

A table of multiple values was supplied where a single value was expected.

Hope some one can advise me where go wrong ?

Paul

[PhilipTreacy · Accepted solution]

Hi @admin11 

FILTER returns a table, and you are trying to create a Measure?  A measure can only return a single value, not a table - hence the error.

What is it you are trying to do exactly?  

Can you please supply your PBIX file.

regards

Phil

[admin11]

@PhilipTreacy 

Thank you very much for your reply to my post. Base on your reply , i will try to figure out how to solve it. in case i still unable can i post a PBI to you by send private msg to you.