Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Custom SORT

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 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.