Forum Discussion

LeaRupnik's avatar
LeaRupnik
Icon for Helper III rankHelper III
4 years ago

Top 10 on values

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 ...
Need Help
LeaRupnik's avatar
LeaRupnik
Icon for Helper III rankHelper III
4 years ago

i don't want without a top 10 column

 

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

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