Measure syntax / best approach

[PowerWhat]

Probably a really simple one, but I can't figure this out...

I've been trying to create a new measure :

1. Qualified:= GameTime < TimeOut

Dim.GameType

GameKey, Name, TimeOut

1, Runner, 600

2, Jumper,300

Fact.Game

GameKey, Speed,SessionKey

1, 210,1

1, 300,1

1,50,2

1,300,2

Measure: GameTime:=SUM(Fact.Game[Speed])

So the data here should show two individual game sessions, one of 510 ms, the other 350ms which should be evaluated against the corresponding Game Type's TimeOut. There is a relationship on the GameKey between the two tables in AAS.

Can anyone offer a pointer for me please?

[parry2k · Accepted solution]

@PowerWhat try this measure

Qualified = 
VAR __TimeOut = CALCULATE( MAX( GameType[TimeOut] ), CROSSFILTER( GameData[GameKey], GameType[GameKey], BOTH ) )
RETURN [GameTime] < __TimeOut

[PowerWhat]

Just what I needed, thanks!