Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
JCik
New Member

Calculated Row and Ranking

Hi-

 

I have a table that has zip codes for rows and segmentation counts as columns.  I am agreggating on our trade areas, which is a set of zip codes.  I want to be able to have a visualization that shows me the top 5/10 etc segments present in this trade area.  Any idea how this could be accomplished?

 

Example.PNGThanks!

4 REPLIES 4
MFelix
Super User
Super User

Hi @JCik,

 

The easist way is to use the TOPN filter option on the visual level or report level, if you want you can also use the RANKX function. However both of this options need to have a column as referenced to make the TOPN can you give based on the sample data and expected result and to what column you are comparing?

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Thanks!  But I don't think that will work for this

 

In the example below I would only want to have the top 3 columns pulled into a visual or at least have a row below the totals with the ranking of that column so Money & Brains would be #1, Yound Digerati #2 etc

 

samp.PNG

Hi @JCik,

 

What's "Money & Brains" in your first post? I'm afraid we can't add columns dynamically. I would suggest you unpivot these columns or create a new table.

 

Best Regards,

Dale

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

Money and Brains is a segment name (PRIZM segmentation).  Essentially my table consists of every zipcode in America as rows and then the 68 different segments as columns with # of HHs that fall into each segment as values.  We have defined trade areas (custom set of zip codes) that i wanted to show the dominant 5 segments in those areas but suspected that it might not be able to be done.

 

Thanks!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.