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

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi ArlenioPaiva ,

     

    Please do.

    Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

    If the information is sensitive please share it trough private message.