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) )
Deku
Super User
1 year agoTry this
TopTeam =
VAR TopTeamTable =
ADDCOLUMNS(
Filter(
ALL(Table15924[Redirection to?]),
Not ISBLANK(Table15924[Redirection to?])
),
"@Count", CALCULATE(COUNTROWS(Table15924))
)
Return
MAXX(
TOPN(1, TopTeamTable, [@Count], DESC),
Table15924[Redirection to?]
)