Forum Discussion
Solved
Incomplete Mapping Table
Hi, I have two tables, the first is like this: Country Sales France £10000 UK £5500 UK £6000 Italy £2000 I then have a second table: Country Code France FR ...
Hi ompowerbi ,
Here are the steps you can follow：
1. Create calculated table.
Table = SUMMARIZE( 'Table1','Table1'[Country],'Table1'[Sales],"1", MAXX(FILTER(ALL(Table2),'Table2'[Country]='Table1'[Country]),[Code]) )2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi ompowerbi ,
Here are the steps you can follow：
1. Create calculated table.
Table =
SUMMARIZE(
'Table1','Table1'[Country],'Table1'[Sales],"1",
MAXX(FILTER(ALL(Table2),'Table2'[Country]='Table1'[Country]),[Code])
)
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Genius