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 advance

 

Kind Regards

 

Julien Nicaise

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 

1 Reply

  • 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