Need help to get top 10 values of Gross invoice amount per user

[KuntalSingh]

Hi Team

I need help  to get the sample of every users on the basis of top 10 gross invoice amount per user.

Company Code	Document Id	Current Agent	Gross invoice amount
9240	2000876918	Shubham	36714
100	2000809485	Anju	22875622
9060	2000875950	Shubham	85518.02
9030	2000866446	Anju	19375483.73
1200	2000872146	Garima	2463930
9030	2000874847	Anju	8485980
9240	2000871904	Anju	351404.68
9070	2000755331	Anju	5106282.44
9050	2000871145	Garima	2201834
9050	2000871143	Garima	2266592
4400	2000861694	Kanupriya	21506289.84
9050	2000861186	Garima	2190224.23
9050	2000860607	Jitesh	1626179.53
9050	2000857056	Jitesh	161318.15
9050	2000828781	Garima	2579010
9050	2000828780	Garima	2579010
1300	2000876862	Anju	24768
9060	2000876360	Neetu	282185.84
1100	2000875612	Kanupriya	3973720.8
9030	2000874832	Kanupriya	186422.4
9030	2000874132	Kanupriya	115206
1100	2000873783	Kanupriya	122041.5
1100	2000873773	Kanupriya	138431
9500	2000873095	Kanupriya	149120
4100	2000872766	Kanupriya	236468.17
9030	2000868028	Raghav	50535.16
1100	2000822759	Ankita	76853.4
9270	2000868021	Jitesh	138493.01
9030	2000840440	Ankita	433708
1200	2000720674	Ankita	68885.65
9270	2000867939	Jitesh	107685.71
1100	2000867937	Garima	2493817.62
9050	2000867892	Garima	2256633
9050	2000867887	Garima	2256633
1100	2000867757	Jitesh	1115406.81
9020	2000867682	Kanupriya	2036418.05
9500	2000867679	Kanupriya	1606701
100	2000867620	Jitesh	337826
100	2000867619	Jitesh	1180
100	2000867618	Jitesh	338121
100	2000867617	Jitesh	1180
100	2000867614	Jitesh	294985.13
9060	2000867603	Jitesh	1140110.46
1100	2000867072	Kanupriya	2260326.05
1500	2000866854	Kanupriya	1858254.09
1100	2000866621	Kanupriya	1745529.12
1100	2000864948	Neetu	71923.8
1100	2000864947	Neetu	71923.8
1100	2000864946	Neetu	71923.8
1100	2000864945	Neetu	71923.8
1100	2000864943	Neetu	71923.8
1100	2000864940	Neetu	71923.8
1100	2000864939	Neetu	71923.8
1200	2000864847	Raghav	2500
9240	2000864636	Raghav	96048
1500	2000864627	Raghav	2740.03
9030	2000864540	Raghav	572632
9030	2000864533	Raghav	2196633
100	2000864456	Raghav	8604.97
100	2000864452	Raghav	10357.46
9060	2000864286	Shubham	1978812.8
9200	2000864205	Raghav	12960
9200	2000864202	Raghav	54000
9200	2000864201	Shubham	283500
9000	2000864158	Raghav	611484
100	2000864023	Raghav	224000.58
9060	2000863874	Raghav	270900.01
9050	2000863762	Raghav	866599.23
9050	2000863760	Raghav	210188.67
9100	2000863402	Raghav	247893
9030	2000862913	Neetu	527311.44
9060	2000860025	Shubham	7508615.86
9100	2000860018	Shubham	2124000
9030	2000857815	Shubham	32431615.6
1500	2000856799	Shubham	871698
1200	2000856731	Shubham	1521380
1200	2000856089	Shubham	1283172.23
1100	2000855998	Shubham	71453
1100	2000855996	Shubham	121885
1500	2000855288	Shubham	20994.75
1500	2000855286	Shubham	22700

[v-stephen-msft · Accepted solution]

Hi @KuntalSingh ,

To get the sample of every user on the basis of top 10 gross invoice amount per user in Power BI Desktop, you can follow these steps:

1.Open Power BI Desktop and load the data from your table.
2.Create a new measure to calculate the total gross invoice amount for each user. You can use the following DAX formula:

TotalAmount = SUM('YourTableName'[Gross invoice amount])

Replace 'YourTableName' with the name of your table.

1.Create a new table visual and add the Current Agent column to the Rows field and the TotalAmount measure to the Values field.
2.Sort the table by the TotalAmount measure in descending order.
3.Right-click on the table and select "Top N" from the context menu.
4.In the "Top N" dialog box, select "Top" and enter "10" in the "N" field.

5.Click "OK" to apply the filter.

This will give you a table with the top 10 users based on their gross invoice amount. You can then use this table to create a sample of every user.

Here's the example. I set up TOP 3.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[ThxAlot]

INVC.pbix