topn

  1. I

    DAX measure that filters a table to a single row and returns text from a specified column (Excel365)

    Hi everyone 😊 I still have a lot to learn about DAX and have become stuck trying to develop a measure that will filter down my source table to a single row by using values in two columns and return the (text) value from a different, specified column. I have two measures that filter a table and...
  2. D

    DAX TOPN function

    Hi, I've been trying to use topn to get the Nth hightest, selling item, I've tried ; EVALUATE TOPN(4,VALUES( Table1[Item]) ,[totalUnits] ) and then thought to wrap this in a MINX to get the 4th top Item,, MINX( TOPN(4,VALUES( Table1[Item]) ,[totalU] ), Table1[Item] )...
  3. B

    TOPN of 3 Other Columns

    I'm fairly new to PBI so please be gentle. I know Excel and VBA so any DAX input should be fine, I'm just not used to PBI terminology or syntax yet. So, I have a dataset that is simple, but huge (5million+ rows). It is set up basically like this (not actual data): Month Location Item...
  4. S

    TOPn SOLD vs OH

    Hi, I’m trying to build a measure to list the TOP 10 models and what our inventory levels are for those items. I would rather use CUBIC formulas but since the list of the TOP items changes each day I am limited to a Pivot Table. I could have another pivot table and use a vlookup. But that...
  5. S

    TOP 100 by month, need help.

    Hi, I've created a PowerPivot DAX measure to list my TOP 100 Brands. I would like to find a way to see for the month of May 2019 vs 2018 vs 2017. The measure below shows me each year total compared side by side. I would like to have a slicer control the month. TOP 100 BRANDS:=VAR RankingContext...
  6. J

    Building a dynamic “Top N” Group and “Other” based on Last 12 Months Revenues

    Hello dear Power Bi Community, I'm pretty new into Power BI, so please excuse if I might need some pretty basic help here. I was trying to find some help here already and eventhough similar posts exist, I didn`t find anything yet which would cover my specific needs. I would like to...
  7. S

    Sum of TOPN by Filtered Date Range

    Trying to have a measure provide the same results as only the Grand Totals of the following vanilla PivotTable. Table AcctList Fields, [DueDate], [Amount], [Name], [Validated/Held] Page Filters = [Validated] = “Validated” Rows = [Name] Columns= [DueDate] Sigmas = Sum of [Amounts] Row Filter =...
  8. M

    Remove filter from results of SUMMARIZE

    I have created a measure to look at the top 500 SKUs (by forecast) which are then bucketed into forecast unit volume groups returning count of SKU. The measure works at company level but when a hierarchical range slicer is included on my pivot, this slicer also acts on the summarize function to...
  9. S

    Apply Pivot table filter from results of another pivot table

    Hi I'm in need of some help. I've created a Pivot table based on a TOPn Rankx result. It provides me with a list of the top 10-25 items sold. I want to use the results from that table to filer the products details pivot table. I've been able to create VBA code but I can only filter the first...
  10. L

    Listing top 20 values with multiple data sets

    Hi all, This is my first post and I'm in need of some desperate help please. I have a table with the following data (this is example data): <tbody> A B C D Branch Code Product Code Supplier Name Over-Stocked 10 <tbody> ALTA80125-0.00 </tbody> SUP 1 20 10 <tbody> ALTA802-0.00...
  11. E

    TopN Dax Formula in Power Pivot

    Hi all, In PowerPivot I have a table with a list of product ID's in one column and total sales for each product in the next column. I am trying to figure out how to use that information to easily create a slicer in my Pivot Table that I can click to show the top five selling items. Please let...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top