PERCENTILEX.EXC help

[liran]

hi, trying to get the 40% percentile from the column i created in the summarize table,

however it says the expression specified in the query is not a valid table expression

PERCENTILEX.EXC (
    SUMMARIZE (
        FILTER (
             Panel,
            Panel[PermanentConsumer] = "1"
                && Panel[ValidConsumer] = 1
                && Panel[Stores] = 1
        ),
        Panel[Member_ID],
        "Qsales", SUM ( Panel[SelectedQty] )
    ),
    [qsales],
    0.4
)