CODEWITHSUNDEEP
powerbidax
mdevm
mdevm

Reputation: 97

How to display top 3 highest amount info for a record from a table?

For one of the tables imported into the PowerBI, I have columns as Company Name, Debit Amount, Credit Amount and Net Amount (Calculated column: Debit Amount- Credit Amount).

Now is it possible to pull the three highest Company Names from the table in terms of having either higher Debit, Credit or Net Amount and display it on a tile? May be by creating a measure using DAX or OOTB? It should look like:

Top Grossing             Second Grossing       Third Grossing 
12000(Net Amount)        10000(Net Amount)     5000 (Net Amount)
Company Name             Company Name          Company Name

I am envisioning the above in terms of tiles and they would change dynamically once anything updates in the data source table. Not sure if this is possible to do using DAX, I am open to suggestions. Any help will be greatly appreciated. Thanks. enter image description here

Upvotes: 1

Views: 210

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40264

DAX has a TOPN() function that you can use for this sort of thing.

The other possibility is to use the built-in advanced filtering. Under the visual level filters, choose filter type Top N, pick how many you want to show and what value you are sorting by.

Top N filter

Upvotes: 1

Related Questions