Thank you véry much for your response, however the size of the real data not allow to join with itself.
I have considered this approach but it really makes my dataset blow up.
And as the workbook involves a lot of calculations, because of the duplication, all those calculations should be redone and this is not a viable option in my case.
Since you're trying to compare each of the
[Country Destination] dimension value
with the vector of [Country Origin] values --
all in one pass -- then join would seem
a most convenient solution for that.
As an alternative, all-Table-Calculations approach
would be used, but it would require the whole dataset
to be on VizLOD (excluding [Row ID] if not needed).
So the feasibility and the performance of this approach
remains to be questioned. Anyway, please find the attached.
Example_YF.twbx 22.5 KB