DAX - Top X and then....others :)

Hi,

I need help on a DAX query.

I would like to return in a dataset, the top X elements (lets pretend X = 10) and then aggregate all the other elements in bulk "Others". Is this possible to do in DAX?

I know I can use TOPN function for the top 10, but then how can I instruct to aggregate all the rest and then represent it on the dataset?

Thank you

July 3rd, 2015 10:28am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics