I noticed that you blended the data - is there a reason you decided not to Join the data -
see the attached - joined on your 4 fields
and it will produce a text viz like this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you Tushar. It seems to resolve the proble but another problem appears.
The population is wrong when I add a filter per date.
I should have 7,239,782 inhabitants instead of 863,151
Maybe because there is no date column in the population form
I tried to resolve the problem by calculating a Population field that will ignore the Date filter but it doesn't work:
Any idea on how to resolve the population problem
As suggested by Jim, why don't use joins?
thank you for your advise.
I first tried with join but i had duplicated rows generating overcounting (for the final results I will add other files).
I tried to work with LOD expression to resolve overcounting problem but it was too painfull so i've decided to try with data blending.
Thank you for your answer.
Could you send me the workbook so I can analyse it?
Your Blend tricks resolves the problem for this particular exemple but it does not resolve my issue as I have to add a geographic filter (commun on both tables).
To do so I have to activate the link on the administratives levels (Region / Province / District / LLG).
If I do so, I obtain weird population results.
Without administrative filters (results are good):
With the administrative filters the results are not good