No correct calculation rows

Hi, Anonymous 

I assume that there is something wrong with your data model. I'd like to suggest you use a star schema instead of circle schema.

Cross filtering both directions works well for a pattern of table relationships such as the pattern above. This schema is most commonly called a star schema, like below:

If you have a table pattern like below, with loops, then cross filtering can create an ambiguous set of relationships. For instance, if you sum up a field from TableX and then choose to filter by a field on TableY, then it’s not clear how the filter should travel, through the top table or the bottom table.

For further information, please refer to the official document .

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.