Rank Dax help

hi everyone Need your help to get Rank Dax . Below table is the requirement. rank dax should be based on name and solutions for FY basis. for ex:- A name with abc solution in FY23 should be ...

General Comment

Need Help

Show and Tell

Tips and Tricks

Tutorial Requests

Anonymous
3 years ago
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.
Sample452.pbix31 KB

tackytechtom

Most Valuable Professional

3 years ago

Hi riishabhzz ,

Here a solution in DAX for a calculated column:

Here the DAX code:

Column = 
RANKX ( 
    FILTER ( 
        'Table', 
        'Table'[solutions] = EARLIER ( 'Table'[solutions] )
    ),
    'Table'[FY],
    , DESC
    , DENSE
)

I used the DAX ranking code example from here.

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/