Forum Discussion
TOP 2 Users By Report
Here's the solution. I had to pick another column:
And then I added the column and a page filter. I selected the top 2. That worked.
Thank you for your help. You steered me in the right direction.
---MW
Super UserHi Anonymous
You can add a new column with RANKX:
Column =
RANKX(filter(all(table),table[Name]=earlier(table[Name])),table[ReportViews],,ASC,DENSE)
then you can add that column to your visual filter section and filter to show 1 and 2.
Can you share a sample of your data in a text or table format to be able to copy and paste that? then we can use your data to prepare better solution.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Thank you for the reply. The formula works to show a count, which I already had. But when applying a filter, it doens't return only the top 2 of each user as expected.
Note that the "reportedview" column is a calculated column. There are thousands of entries per report.
Here's some sample data:
NAME ReportViews USERNAME AccountLeadOwner 129 IIC2\svcAppPool2G ASSETCHANGER-TFR-TXN 10 IIC2\ccrespo AssetDiscrepancyReport 240 IIC2\svcSQLRSAP05 Audit_Report 42 IIC2\svcSQLRSAP05 Audit_Report_Rollup 18 IIC2\egonzalez Audit_Report_Rollup 42 IIC2\svcSQLRSAP05 BookedReport 2 IIC2\kanti BookedSalesReport 1 IIC2\svcAppPool2G Cash App Recon Details Report 77 IIC2\aruiz Cash App Recon Details Report 2 IIC2\vambrose Commissions 6 IIC2\extrbravo Commissions 18 IIC2\kanti Commissions 1 IIC2\svcAppPool2G COOShipmentTracking 1492 IIC2\svcAppPool2G CORPSMAP05 SSRS Report 1 IIC2\!ccrespo Current and Prior Year History with Parameters 30 IIC2\egalan Current and Prior Year History with Parameters 4 IIC2\mdold Current and Prior Year History with Parameters 35 IIC2\rdomke Current and Prior Year History with Parameters 82 IIC2\smontelius Current Balance 22 IIC2\dhernandez Current Balance 25 IIC2\egalan Current Balance 5 IIC2\mmagee - VahidDM
Anonymous
Add a new column with this code:
Rank = RANKX(filter(all('Table'),'Table'[Name]=earlier('Table'[Name])),'Table'[ReportViews],,DESC,DENSE)Output:
then create a visual and add the new column (Rank) to the filter pane for that visual and set to show the 1 and 2.
Out put:
Download the file: https://gofile.io/d/TOkKKD
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/Here's the solution. I had to pick another column:
And then I added the column and a page filter. I selected the top 2. That worked.
Thank you for your help. You steered me in the right direction.
---MW