How to combine 2 union expression into 1 ?

[admin11]

Hi All

I have below expression at SOURCE table working fine :-

Source =

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

return

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

Source =

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

return

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

May i know how to combine above 2 expression into 1 ?

I try below but i get error :-

Source =

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

return

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

Paul

[sevenhills · Accepted solution]

Source =

var _1=DISTINCT(

  UNION(all(SALES[SOURCE]), 

               all(GL[SOURCE]),

               all(TARGET_[SOURCE])

     )

)

return

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

Check this https://dax.guide/union/ for syntax.

[admin11]

@sevenhills @Anonymous 

Thank you very much for both your reply , it work fine.

[Anonymous]

HI @admin11 

try 

UNION(UNION(all(SALES[SOURCE]), all(TARGET_[SOURCE])),(GL[SOURCE]))