Could you please attach the data as twbx format.
Answering my own question:
I blended twice to the target dataset, first blending table has each country except ALL, second blending only has ALL.
Then used this formula:
then avg([Target - Country].[Target])
else avg([Target - ALL].[Target])