Forum Discussion
Problems with syntax in combination with Related
Thta is interesting. So it can matter from which table the relationship is created?
BartVlek Not really from which table the relationship is created, but the cross filter direction.
To simplify things, if the arrow does not point to the total table, you will not be able to pull discount columns into a calculated column in total table using RELATED. If the chain of relationships goes through another table, the arrows always have to point to the total table.
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.