Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Using rankx and calculate

Hi everyone,   So I used rankx in order to rank sales by client. My client asked me to show TOP 30 clients by sales, I did that filtering the object to show those 30. But my client also wants me to...
Need Help
Tips and Tricks
TCarrasquillo's avatar
TCarrasquillo
Helper II
6 years ago

I'm pretty sure you  just have to turn it around and use a switch statement like

%Top 30 = Switch (true(), ranking<=30, calculate(sum(sales))

You might not need the true( ) expression but, that is a place to start and it would allow you room to calculate the others as well I think.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi, thank you for answering. Power BI allowed me to calculate the measure but it showed the total amount of sales.

     

    Facturación = sum('BBDD UTMS'[Total Neto Faena USD]) ; total amount= $ 25.335.100

     
    Ranking = RANKX(ALL('BBDD UTMS'[Cliente Madre]);CALCULATE(sum('BBDD UTMS'[Total Neto Faena USD])))
     
    TOP 30 = SWITCH(TRUE();[Ranking]<=30;[Facturación]); total amount= $25.335.100 and it should be $21.386.471
     
    What should I do?
     
    Thank you :)
     
     
     
     
    • TCarrasquillo's avatar
      TCarrasquillo
      Helper II
      6 years ago

      I'm not totally sure, It seems like it's just not pulling out the ranked as it's supposed to. I would try using ALLSELECTED instead of ALL in your ranking measure.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Changing to allselected didn't work :( Thank you for answering, though :)