Is it possible to do a top N1-10 customers vs brands matrix, with N11+ customers agregated to other?

[Anonymous]

Dear all,

I work for a alcohol / spirits company, at the moment I am trying to create a matrix table visualisation.

Desired column ordering - Top N1-10 customers with N11+ aggregated into an "other" line

Rows - these are the brands ideally ordered by biggest first but I think I can do this in the visualisation formatting

Matrix Values - this will be Actuals Vs Budget variance - which I currently have as a measure.

I am just wondering how to achieve the column ordering, if I make a calculated column using Rank will still work when people use the slicers e.g. on countries / regions?

Alternatively I was thinking of making 10 measures instead one for each N...but this would create a lot of measures, especially if I want to also do actuals vs PY

[Anonymous]

First, a calculated column is STATIC, not dynamic. So, once you calculate the rank, it'll not respond to any filtering. Second, it's not DAX measure competence to create such a grouping. You have to have a visual that does it for you, that is, is able to get TopN customers and aggregate the rest into 'Others.' Of course, it's possible to write a DAX query that does it but it's a query, not a measure. Such a query should be written behind the scenes by a suitable visual.

Best

Darek