How to handle Blank Rank rows in table visual in Power BI

[AnjanaTh]

I have a total rank measure ,which is getting derived with another measure ,for some rows I am getting blank in rank measure due to no value in another mesure .My requirement is that i want the blank rank rows to always be in below weather the user sort it in ascending or descending in the table visual in power bi . Right now when user is sorting it in ascending the blank is coming on top .is there any way to achieve it . I dont want to assign the blank ranks any value ,it should be always blank.

[Anonymous · Accepted solution]

Hi,@AnjanaTh. I am glad to help you. 
Hello,@foodd, thanks for your concern about this issue.

And I would like to share some additional solutions below.

You can exclude null measures by nesting an if judgment outside of the sort, and then sort on the remaining non-null values.
Below is my test

this is my test data:

I create two measures to implement sorting based on the value of the measure.
Here is my DAX code:

M_1 = IF(SELECTEDVALUE('Table'[Score])=0,BLANK(),SELECTEDVALUE('Table'[Score]))

M_Rank_NotBlank = 
IF(
    ISBLANK([M_1]),
    BLANK(),
    RANKX(
        FILTER(
            ALL('Table'),
            'Table'[Subject] = MAX('Table'[Subject]) && NOT(ISBLANK([M_1]))
        ),
        [M_1]
    )
)

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.