Custom SORT

[Anonymous]

Hello,

I have created a Rank based on geography. But my geography sequence order is distorted.

I have created a Sort Order Table and assigned a sequence number. But when I use sort order geography than I am unable to populate Rank.

I am attaching my dashboard for reference.

Can anyone support me in creating CUSTOM SORT with Rank.

DAX Code:

Rank2 =

VAR __REGIONS = { "East Region", "West Region", "North Region", "Central Region" }

RETURN

    IF (

        SELECTEDVALUE ( DataTbl[Geography] )

            IN __REGIONS --rank will still show for US so a conditional statement needs to handle this.

                && ISINSCOPE ( DataTbl[Geography] ),

        --to remove rank from the total

        RANKX (

            FILTER ( ALL ( DataTbl[Geography] ), DataTbl[Geography] IN __REGIONS ),

            CALCULATE ( [ShrChgProA], KEEPFILTERS ( DataTbl[Product] = "Prod A" ) )

        )

    )

Rank Table without sortSort Sequence

https://spaces.hightail.com/receive/BzqyRCwQmP 

[Anonymous]

Hi @Anonymous ,

1. You can click the three dots in the upper-right corner of the visual object to choose which field to sort according to, and you can also choose ascending or descending order.

2. You can also directly click on the column name, after which the table visual object will sort according to the selected column.

3. In addition, I made some modifications to the measure to make sure the sorting is correct.

Rank2 = 
VAR __REGIONS = { "East Region", "West Region", "North Region", "Central Region" }
VAR _result = IF (
        SELECTEDVALUE ( DataTbl[Geography] )
            IN __REGIONS --rank will still show for US so a conditional statement needs to handle this. 
                && ISINSCOPE ( DataTbl[Geography] ),
        --to remove rank from the total
        RANKX (
            FILTER ( ALL ( DataTbl[Geography] ), DataTbl[Geography] IN __REGIONS ),
            CALCULATE ( [ShrChgProA], KEEPFILTERS ( DataTbl[Product] = "Prod A" ) )
        )
    )
RETURN
    IF(ISINSCOPE(DataTbl[Geography]) && _result = BLANK(),5,_result)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[Anonymous · Accepted solution]

@danextian Can you take a look on Custom Sort with respect to Rank.