Forum Discussion

BUserTG's avatar
BUserTG
Frequent Visitor
5 years ago

Apply filter to exclude certain rows from PERCENTILEX calculation

I have a sales dataset and am trying to use the PERCENTILEX.INC function to identify certain percentiles (25% and 75% quartiles specifically). Due to some outliers and noise in the data, I want to ex...
Need Help
BUserTG's avatar
BUserTG
Frequent Visitor
5 years ago

Not sure that will apply the same context as the ALLEXCEPT() that is needed to ensure the summarized table does not get filtered down. The calculation you wrote will end up applying filter context on each row.

Kaii's avatar
Kaii
Icon for Helper I rankHelper I
2 years ago

have you figure out yet? I am facing the same issue