Top 10 on values

[LeaRupnik]

Hello,

I have to make a hierarchical table of the top 10 customers by the amount of im margin.

I know how to limit the quantity, the problem is that it does not limit it for all organizations, how could I limit the margin to the top 10 quantities.

I am adding an example in the attachment

The wish is to get like this

example:

https://drive.google.com/file/d/1E1pdjB1xKWsCqKTjEE2J3YUH_mAUyyJF/view?usp=sharing

thx

[LeaRupnik]

Thanks,
this works, but I'm having trouble sorting.
I have a measure now
Količina =
var _max = MAXX(ALLSELECTED('nov_27'), nov_27[datum_posnetka])
return
CALCULATE (
SUM (nov_27[izdkol] ),
FILTER ( ALL ( nov_27), nov_27[datum_posnetka] = _max),
VALUES(nov_27[kupec]), VALUES(nov_27[progenot]))

and the measure of sorting
Top 10 po kolicini = RANKX(ALL(nov_27[kupec]), [Količina],,DESC)

the table I show can be sorted both under LU_PCP and LU_FT, and within that then the quantities are fitted. I can't show the Top 10 columns

new version powerBI
https://drive.google.com/file/d/1IZGEzxdqw84VZ4dCymFQdE_oi0XX-otv/view?usp=sharing

thx

[SpartaBI]

@LeaRupnik isn't this what you want?

[LeaRupnik]

i don't want without a top 10 column

[SpartaBI]

@LeaRupnik try this:
Only write this measure:

Količina = 
VAR _max = MAXX(ALLSELECTED('nov_27'), nov_27[datum_posnetka])
VAR _result = 
 CALCULATE (
    SUM (nov_27[izdkol] ),  
    nov_27[datum_posnetka] = _max
)
VAR _rank = 
    RANKX(
        ALLSELECTED(nov_27[kupec]), 
         CALCULATE (
            SUM (nov_27[izdkol] ),  
            nov_27[datum_posnetka] = _max
        )
            ,_result
            ,DESC
    )
RETURN
    IF( _rank <= 10, _result, BLANK() )

No need for the visual level filter:

Showcase Report – Contoso By SpartaBI

      

[BurgerToPro]

You should be able to use the filter tab and unselecte the 'empty' values for the measure 'Top 10 kupcev'