Forum Discussion

PowerWhat's avatar
PowerWhat
New Member
7 years ago
Solved

Measure syntax / best approach

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?

Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    PowerWhat try this measure

     

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

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    PowerWhat try this measure

     

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