DAX TOPN function

I think you mean something like this?

Please Login or Register  to view this content.

To retrieve result 142 please try

Formula:

Please Login or Register  to view this content.

but I don't understand the calculations of TOPN wanted pro item.
Why is that for item A 121?

That, certainly give the correct, total, but I stll figure out what it's doing drop the item into a pivot table ,
81, 49 , 50 42 , with even with my math's don't make 142, still thanks. One thing, when I tried your formula in DAX studio it returned an error, but worked fine in 'reality', curious, which just about sums up the function.

rd

NB the reason the dax studio didn't work is I forgot to add the { } to scaler, suddenly realized making tea.

Measures do the same calculation at every level. 142 is not the sum of the other numbers. It's the sum of all values matching the top 3 values overall.

I'm glad t o have helped and thanks for the feedback and rep .

Originally Posted by Dicken

Re Item A giving 121, I don't know either I've been trying to see what its calculating to get that, if I fgure it out I'll let you know.


rd

It's the top 10 rows for A. If there is a tie at the last item (as here), it includes all rows matching that item, so you get both 7 values.