DAX Count Top N Distinct Occurence

[Noexicaise]

Hello,

I would like to create a column or measure that calculates the sum of the 10 largest occurrences listed in the Number column. In this case it should be: 3288 + 2031 + 970 ...

Thx in advance

Kind Regards

Julien Nicaise

[Anonymous · Accepted solution]

@Noexicaise Please create a measure 

Measure = CALCULATE(SUMX(TOPN(10,VALUES('Table'[Number]),'Table'[Number],DESC),'Table'[Number]))

Let me know if you have questions