Forum Discussion

Noexicaise's avatar
Noexicaise
Frequent Visitor
6 years ago
Solved

DAX Count Top N Distinct Occurence

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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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