topic Re: How to create a view with the largest three values for each row in DAX Commands and Tips

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

Sixian — Thu, 21 Jan 2021 08:35:23 GMT

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/How-to-filter-a-page-with-different-attributes-using-the-same/m-p/1613382#M32457

Problem 2.

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

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

I would really appreciate any help.

Thank you

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

wdx223_Daniel — Thu, 21 Jan 2021 08:58:55 GMT

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

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

Sixian — Thu, 21 Jan 2021 11:56:56 GMT

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

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

wdx223_Daniel — Thu, 21 Jan 2021 13:06:05 GMT

think you can use generate instead of addcolumns

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

Sixian — Tue, 26 Jan 2021 14:37:09 GMT

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