Sorting matrix column value based on measure

Hi Anonymous ,hello rajendraongole1 ,

Thanks for your prompt reply!

As rajendraongole1 suggested, we need to create a measure to rank the Product1 based on Top 10 region filter.

Rank_WITH_ ALLSELECTED = 
RANKX (
    ALLSELECTED(  'Table (2)'[Region] ),
    CALCULATE ( SUM ( 'Table (2)'[Product1] ) )
)

Then sort the visual based on that rank measure as shown below:

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

Best regards,

Joyce

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