Forum Discussion
Solved
How to calculate TOPN
Hello. I have the following table: CycleID, UserNAme,CustomerID, score. I want to create a formula that sums the top 10 scores within cycleid,username. Any suggestion? I have been tryin...
Hi mbosch
Is this what you want (I take top 2 as an example)? If not, can you please provide some dummy data and expected result that we can work with?
Measure = SUMX(TOPN(2, 'Table', 'Table'[Score], DESC), 'Table'[Score])Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hello.
It doesnt work. It is not summing the top 10. Any alternative?