Pulling measure values from views inside union block

[vidhyaravi]

I have a use case where we have a union view. This view joins 3 views with UNION join and with WHERE conditions. But the measures do not live in this view , where they could be calculated from the results of this union. These measures actually are coming from the views joined in the explre with LEFT OUTER join and without WHERE condition . 

Is there a workaround to have measures calculated at the union block?

[kpmartin87]

Only way I could think about having it work is adding in the relevant joins in the sql statement.
 

select date, shop_brand, traffic_souce, paid_organic
from ${no_agg.SQL_TABLE_NAME} as a
left join ${measure_table.SQL_TABLE_NAME} as m
on m.no_agg_id = a.id
union distinct
...