Incorrect values and Timeout due to Relationships

[y5famfnatudu]

Hello all,

I have 2 issues with the attached dataset:

1. Measure is showing same value for all records.
   
2. Timeout of Table visual, when a related column is added to the table
   

The pbix file can be found here: pbix file 
Your help is so much appreciated.

Best regards,

Simon

[y5famfnatudu · Accepted solution]

I got the solution, the issue was the single direction of the relationship between the 2 tables used. And the solution was using the function 'crossfilter' in the measure, so that the relationship direction turns into BOTH.