Forum Discussion
roger360
1 year agoFrequent Visitor
Getting Syntax Error: Invalid Token, Line 3, Offset2, .
TopTeam = VAR TopTeamTable = ADDCOLUMNS( SUMMARIZE( FILTER( Table15924, NOT(ISBLANK(Table15924[Redirection to?])) ), ...
- 1 year ago
Hi roger360 ,
Here’s a corrected version of your measure:TopTeam = VAR TopTeamTable = ADDCOLUMNS( SUMMARIZE( FILTER( Table15924, NOT(ISBLANK(Table15924[Redirection to?])) ), Table15924[Redirection to?] ), "Count", CALCULATE(COUNTROWS(Table15924)) ) VAR MaxCount = MAXX(TopTeamTable, [Count]) RETURN CALCULATE( FIRSTNONBLANK(Table15924[Redirection to?], 1), FILTER(TopTeamTable, [Count] = MaxCount) )