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
SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

LeaRupnik isn't this what you want?

 

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:


    In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.

    Showcase Report – Contoso By SpartaBI


    Visit SpartaBI website   Visit SpartaBI Linkdin   Visit SpartaBI Facebook

    SpartaBI Logo