Forum Discussion
Rank Dax help
Hi riishabhzz ,
I noticed that you have three tables and your fields in your table visual are from different tables.
And because of the model relationships, when you put the right rank meausre into it, fields will be changed.
It's a little hard to explain, but that's the way it is.
If you want to keep the expected output when you post, try to make your Name and FY from the Solutions table.
And you'll get the right output.
Rank = RANKX(FILTER(ALLSELECTED(Solution),[Solutions]=MAX('Solution'[Solutions])&&[Name]=MAX('Name'[Name])),CALCULATE(MAX('Time'[FY])),,ASC,Dense)Rank2 = RANKX(FILTER(ALLSELECTED(Solution),[Name]=MAX('Solution'[Name])&&[Solutions]=MAX('Solution'[Solutions])),CALCULATE(MAX('Solution'[FY])),,ASC,Dense)Both measures can return the right values.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi riishabhzz ,
Here a solution for a DAX measure:
Measure =
RANKX(
ALLSELECTED ( 'Table' ),
CALCULATE (
MAX ('Table'[FY] ),
MAX ('Table'[solutions] ) = 'Table'[solutions]
),
, DESC
, DENSE
)
I used the DAX ranking code example from here.
A quick clarification: Both solutions - whether you are creating a calculated column or a measure - is based on the coding language DAX 🙂 So, if you are asking for a help in DAX, one might provide you with a solution either way.
Let me know if this solved your issue!
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Hi tackytechtom
i tried your dax but still its not working 😞
i have attached screen-snip for your refrence
if possible please teach /guide me how to do it 🙂
thank you
Hi riishabhzz ,
Could you try this?
Measure 2 = VAR _value = MAX('Table'[solutions] ) RETURN RANKX( ALLSELECTED ( 'Table' ), CALCULATE ( MAX ('Table'[FY] ), _value = 'Table'[solutions] ), , DESC , DENSE )/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/