Rank Client based on Quantity in Matrix Visual

[timmyeal]

I want to rank client based on quantity in a Matrix visual. However, the client is in a group called Business Group see below matrix:

I want to achieve the screenshot below:

where the BusinessGroup is ordered and Client order based on Quantity as shown above.

I will appreciate the assistance.

[parry2k · Accepted solution]

@timmyeal try this measure to rank client within the business group:

Rank = 
	RANKX (
		FILTER(
			ALL(
				'Table'[BusinesGroup],
				'Table'[Client]
				),
			'Table'[BusinesGroup] = MAX('Table'[BusinesGroup])
			),
			CALCULATE(SUM('Table'[Quantity]))
			)

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k · Accepted solution]

@timmyeal hmm for this you need to create a calculated table and use sort by, or you need to keep the Rank measure in the matrix and use this for sorting.

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k · Accepted solution]

@timmyeal try this measure to rank client within the business group:

Rank = 
	RANKX (
		FILTER(
			ALL(
				'Table'[BusinesGroup],
				'Table'[Client]
				),
			'Table'[BusinesGroup] = MAX('Table'[BusinesGroup])
			),
			CALCULATE(SUM('Table'[Quantity]))
			)

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[timmyeal]

Thanks parry2k. This Rank the client but the goal is to sort the client by the Rank measure. see screenshot of what the rank measure does

the client needed to be sorted by rank.

[VijayP]

@timmyeal 

If you can share your pbix without any senstive data , i can help!

[timmyeal]

@VijayP i have attached a link to my drive https://drive.google.com/file/d/16-G6d0JYlqfftcnvBY4AggX4SruXPNnA/view?usp=sharing 

[VijayP]

@timmyeal 

You can use RANKX(all(client),sum(quantity) and place the rank in the Matrix Row Fields below the Group , you should get it! Let me know if this is not solving the issue

[timmyeal]

@VijayP It didn't work