Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Rank Client based on Quantity in Matrix Visual

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.

 

Need Help
Tips and Tricks
  • parry2k's avatar
    parry2k
    5 years ago

    Anonymous 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's avatar
    parry2k
    5 years ago

    Anonymous 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.⚡

7 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous 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.⚡

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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.

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous 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.⚡

  • VijayP's avatar
    VijayP
    Community Champion
    5 years ago

    Anonymous 

    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

  • VijayP's avatar
    VijayP
    Community Champion
    5 years ago

    Anonymous 

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