Forum Discussion

ArlenioPaiva's avatar
ArlenioPaiva
New Member
5 years ago

Help with Maxx and RANKX

Hi guys, I need some help to solve this problem. I want that the variable MaxRank returns the maximun value of variable rankeamento1. How could i do that? I've tried many ways to put the right resul...
Need Help
MFelix's avatar
MFelix
Super User
5 years ago

Hi ArlenioPaiva ,

 

your explanation is not very clear about your data however believe that you need to do a summarize on your maxrank instead of linking the table directly something similar to this:

 

MaxRank =
MAXX (
    SUMMARIZE ( fStatusInvest, fStatusInvest[Column], "@Rankeamento", rankeamento1 ),
    [@Rankeamento]
)

 

Be aware that since I don't know your data granularity I only used a column but you must include in the summarize all the columns that make part of your context.

 

 

  • ArlenioPaiva's avatar
    ArlenioPaiva
    New Member
    5 years ago

    First of All, thank you for your tentative.

    But i didnt have success with it.

     

    Could i share my project with you to see the problem?

     

    thank you