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 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.