Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi @Anonymous
Please check the solution I have authored
http://community.powerbi.com/t5/Desktop/Anti-Filtering/m-p/119471#M50455
If it works for you please accept this as a solution and also give KUDOS.
Cheers
CheenuSing
PowerBI can only get something out of your datamodel if it is already in there. If you have no mapping between countries and nationalities in your table, there is no way that you can add this into your calculations.
So based on your explanation, you probably would have to put this information in your model. E.g. You can add a table where you map countries-nationalities.
Simpler solution is maybe to not look at nationalities but looking at countries vs countries. E.g. a matrix structure where you map countries of origin on rows and on columns you put destinations. The underlying difference will be that country of residence determines 'local' travel, instead of place of birth (E.g. an Indian living in the UK who travels to India.The goal of your model would be to exclude him from the counts of travelling to India, while in the changed model, he would count as an external visitor)
Anyway without data or further information I am out of ideas, so hope you find a way out
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |