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) )
Anonymous
1 year agoNot applicable
Hi roger360
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.