Forum Discussion

roger360's avatar
roger360
Frequent Visitor
1 year ago
Solved

Getting Syntax Error: Invalid Token, Line 3, Offset2, .

TopTeam = VAR TopTeamTable =     ADDCOLUMNS(         SUMMARIZE(             FILTER(                 Table15924,                 NOT(ISBLANK(Table15924[Redirection to?]))             ),     ...
  • rohit1991's avatar
    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)
        )