How to sort the column in "Desc" order using drill through option?

[Sampathkumar_v]

Hi Folks,

I need to sort by DESC order (Practice column) using Discount in Matrix view.

I have two columns "Project Division" and "Practice" (Project Division column I have make the sequence of BU1,BU2,BU3,BU4,etc till BU10) While creating matrix view using column "Project Division" and "Practice" data shows as below.

When I am doing sort by Discount my project devision sequence also get changed. I want project division should have same sequence what is there at view. how to sort by desc order using Discount by Practice column?

[Anonymous · Accepted solution]

Hi @Sampathkumar_v 

You can create a measure.

e.g 

Measure = IF(ISINSCOPE('Table'[Column2]),RANKX(ALLSELECTED('Table'[Column2]),CALCULATE(SUM('Table'[Column3])),,DESC,Dense))

Then put it into the matrix, and close all "text wrap" and put the widenth of the measure to '0'

and select sort by 'measure' and 'sort ascending'

Output

Best Regards!

Yolo Zhu

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

[Anonymous · Accepted solution]

Hi @Sampathkumar_v 

You can create a measure.

e.g 

Measure = IF(ISINSCOPE('Table'[Column2]),RANKX(ALLSELECTED('Table'[Column2]),CALCULATE(SUM('Table'[Column3])),,DESC,Dense))

Then put it into the matrix, and close all "text wrap" and put the widenth of the measure to '0'

and select sort by 'measure' and 'sort ascending'

Output

Best Regards!

Yolo Zhu

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

[Sampathkumar_v · Accepted solution]

Hi

Thank you it's working as expected. 

[Anonymous]

Hi @Sampathkumar_v 

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

Best Regards!

Yolo Zhu