Forum Discussion
ArlenioPaiva
5 years agoNew Member
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...
MFelix
5 years agoSuper User
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
5 years agoNew Member
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