TopPercent ( set, percentage, numeric_value_expression )
The set from which the top-percentile elements are selected.
The percentile. This argument must be a value between 0 and 100.
The expression that defines the selection criteria.
with
set SSSSSS as filter(descendants(Calendar.[ALL].[2021], 1, SELF_AND_AFTER), (measure.[sales amount]) > 1)
member measure.XXXXXX as (measure.[sales amount]) - 20000
select
topPercent(SSSSSS, 25, (measure.[sales amount])) on 10,
{(measure.XXXXXX)} on 1
from [Online Store] ;
| XXXXXX | |
| Q3 | 2088 |
| Q4 | 1231 |