Forum Discussion
Related column between two tables
Hi, KristofferAJ
Use the following expression to create a calculated table:
Table 2 = SUMMARIZE('APPLE','APPLE'[City],"ORANGE",[Measure])Recreate the relationship as follows:
Since the countries in the ORANGE table do not necessarily include the countries in APPLE, blank values will appear when it is put into the slicer:
So set this column:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is great and works! - I can use it as part of a table, but not as legend or in a filter, suspect thats becasue its a measure?
Any way that this can be made into a column instead? - when I try it gives me the "circular dependency" error
Hi, KristofferAJ
If you still just want to create a calculated column in the APPLE table, you can try the following expression:
Column =
VAR _table = {
("London"),
("Munich")
}
RETURN IF([City] IN _table,"TRUE","FALSE")
You need to structure the countries in your ORANGE table in _table with each bracket representing a row.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.