Yes bit difficult here as I would say not all variables around this scenario are exactly known.

I’m really doubting also whether you even need a calculated column here. I rarely advise using these because you just don’t need them when writing and using DAX effectively in your models.

Here’s some examples that you could use that maybe will help but I really recommend thinking about how you can do what you need using a combination of the right data model and DAX measures.

- If 1:1

calculated column =

table1[X] - RELATED ( table2[Y] )

- If 1:many

calculated column =

oneTable[X]

```
- CALCULATE ( SUM ( manyTable[Y] ), ALLEXCEPT ( manyTable, Table10[linkedCol] ) )
```

Definitely look to review the below courses as soon as you can. In here are many best practices around Power BI development that are must knows early on as you get more and more into Power BI work.

This one here will be a good one for you

Thanks

Sam