Forum Discussion

Sixian's avatar
Sixian
Frequent Visitor
5 years ago

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: https://community.powerbi.com/t5/DAX-Commands-and-Tips...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

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 

 

Sixian's avatar
Sixian
Frequent Visitor
5 years ago

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