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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
eacy
Helper II
Helper II

Column or measure with rows which are ranked in the top 10 with multiple criterium

Hi

 

I am trying to create a list of rows which are ranked in the top 10 in all three lists shown in the screenshot.

 

I have tried without any success to use Top N on one of the measure "CFC" which i the first column in th screenshot.

This actually works if I refer to a column but not a measure.

 

Top id of CFC = 
	IF(
		'jiradb changeitem'[ID] >= MINX(TOPN(10; 'jiradb changeitem'; 
			[CFC]);'jiradb changeitem'[ID]) && 
		'jiradb changeitem'[ID] <= MAXX(TOPN(1; 'jiradb changeitem'; 
			[CFC]);'jiradb changeitem'[ID]
);'jiradb changeitem'[ID];BLANK())

Screenshot3.png

 

So, again if a Name is present in the top 10 of all three column (or in some cases only two columns) it qualifies to be shown in the Combine Top 10 list.

Any suggestions?

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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