cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RohiniP-26
Helper III
Helper III

create rank for each category

Hi All,

Below is my sample data,

RohiniP-26_0-1618981872775.png

I have to create rank (measure) for brands based on Sale amount for each category using matrix visual.

Brand name as row, category as column, sale amount & rank as values in matrix visual.

Ex:

RohiniP-26_1-1618982314646.pngRohiniP-26_2-1618982347172.png

 

 

Thanks...

 

 

 

1 ACCEPTED SOLUTION
Jihwan_Kim
Community Champion
Community Champion

Hi, @RohiniP-26 

Please check the below picture and the sample pbix file's link down below.

 

Picture2.png

 

Sale Amount =
SUM(Data[Sales Amount])
 
Rank =
RANKX(ALLSELECTED(Data[Brand Name]), [Sale Amount],,DESC)
 
 

Hi, My name is Jihwan Kim.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


Linkedin: https://www.linkedin.com/in/jihwankim1975/

View solution in original post

1 REPLY 1
Jihwan_Kim
Community Champion
Community Champion

Hi, @RohiniP-26 

Please check the below picture and the sample pbix file's link down below.

 

Picture2.png

 

Sale Amount =
SUM(Data[Sales Amount])
 
Rank =
RANKX(ALLSELECTED(Data[Brand Name]), [Sale Amount],,DESC)
 
 

Hi, My name is Jihwan Kim.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


Linkedin: https://www.linkedin.com/in/jihwankim1975/

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors