Forum Discussion
Problems with syntax in combination with Related
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.
I am certain the relationship is created correctly.
The syntax error I keep receiving is: Syntax error: expected IN this is after the final bracket
BartVlek , Share a screenshot of the error and final formula. If possible share pbix, after removing sensitive information.
I am not unwilling to that, but my PBI dashboard is all in Dutch ... I just translated for your understanding, but the syntax remains the same. How can I share a screenshot? Sorry very new to this
