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) )
rohit1991
Super User
1 year agoHi 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)
)