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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

How to create a view with the largest three values for each row

I'm struggling with a couple of problems in the same project and I'll post two different help request.

You can find the Problem 1 in this post:


Problem 2.

I have a table with more than 80 Attributes, like this:

ScreenShot 041.jpg

I want to create a page with a view that shows the largest three attributes for each name, like this:

ScreenShot 045.jpg


I would really appreciate any help.

Thank you

Frequent Visitor

I still can't find a way to unpivot my Attributes Table.

I can't do it in power query, because it is a calculated table, created using the following DAX code:

AttributesTable =
var filteredTable = FILTER('InputTable', 'InputTable'[Exclude] = "NO")
return SELECTCOLUMNS(filteredTable,
"Name", 'InputTable'[Name]


Then, all the more than 80 attributes have been added as calculated columns using DAX code.

Please, any help?

Thank you

Super User
Super User

think you can use generate instead of addcolumns

Super User
Super User

firstly, you need to unpivot your data like this


then add a dimension table like this


then create two measures

Attr = CALCULATE(MAX('Table'[Attribute]),FILTER(VALUES('Table'[Attribute]),RANKX(ALL('Table'[Attribute]),CALCULATE(MAX('Table'[Value])))=MAX('TopN'[Index])))
Val = CALCULATE(MAX('Table'[Value]),FILTER(VALUES('Table'[Attribute]),RANKX(ALL('Table'[Attribute]),CALCULATE(MAX('Table'[Value])))=MAX('TopN'[Index])))

then show the view you want 



My Data Table is a calculated table where I added all the Attributes columns using formulas. How can I unpivot the table?

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.