Rank or Topn on a specific field but show remaining detail

vanschex1 — Thu, 09 Nov 2023 04:10:00 GMT

Hi I am after assistance please.

I have a dataset that I want to be dynamically filtered based on a selected number in another filter so that it gives me a ranking on "Vendor Des" based on the total of field "Contract amount". For example if a person chooses 1, all data is filtered for the "Vendor Des" that has the highest value of "Contract amount". If 2 is selected, all data for the first 2 ranked for "Vendor Des" will be shown. I have this working where the table visual only contains the "Vendor Des". As soon as I added other fields, it adds it to the ranking criteria and therefore I get incorrect results. Any help on appropriate DAX measure would be appreciated!

I have the following data:

Vendor	Vendor Des	Contract amount	Contract no	Contract title	Aggregate Contract Value	Rank
Vendor number 1	Vendor Description 1	$1,000	Contract 1	Title 1	$ 500.00	2
Vendor number 1	Vendor Description 1	$2,000	Contract 2	Title 2	$ 1,500.00	2
Vendor number 2	Vendor Description 2	$3,000	Contract 3	Title 3	$ 10,000.00	1
Vendor number 2	Vendor Description 2	$4,000	Contract 3	Title 3	$ 10,000.00	1
Vendor number 2	Vendor Description 2	$6,000	Contract 4	Title 4	$ 5,500.00	1
Vendor number 3	Vendor Description 3	$1,000	Contract 5	Title 5	$ 700.00	3

TopN Variable of 1 expected output

Vendor	Vendor Des	Contract amount	Contract no	Contract title	Aggregate Contract Value
Vendor number 2	Vendor Description 2	$3,000	Contract 3	Title 3	$ 10,000.00
Vendor number 2	Vendor Description 2	$4,000	Contract 3	Title 3	$ 10,000.00
Vendor number 2	Vendor Description 2	$6,000	Contract 4	Title 4	$ 5,500.00

TopN Variable of 2 expected output

Vendor	Vendor Des	Contract amount	Contract no	Contract title	Aggregate Contract Value
Vendor number 1	Vendor Description 1	$1,000	Contract 1	Title 1	$ 500.00
Vendor number 1	Vendor Description 1	$2,000	Contract 2	Title 2	$ 1,500.00
Vendor number 2	Vendor Description 2	$3,000	Contract 3	Title 3	$ 10,000.00
Vendor number 2	Vendor Description 2	$4,000	Contract 3	Title 3	$ 10,000.00
Vendor number 2	Vendor Description 2	$6,000	Contract 4	Title 4	$ 5,500.00

Re: Rank or Topn on a specific field but show remaining detail

lbendlin — Mon, 13 Nov 2023 00:00:34 GMT

Is your Rank value a calculated column or a measure?

Re: Rank or Topn on a specific field but show remaining detail

vanschex1 — Mon, 13 Nov 2023 00:02:31 GMT

Hi. It's a measure

Re: Rank or Topn on a specific field but show remaining detail

lbendlin — Mon, 13 Nov 2023 02:32:47 GMT

see attached

Re: Rank or Topn on a specific field but show remaining detail

vanschex1 — Mon, 13 Nov 2023 05:07:03 GMT

I really appreciate your help on this! Love your approcah

topic Rank or Topn on a specific field but show remaining detail in Developer

Rank or Topn on a specific field but show remaining detail

Re: Rank or Topn on a specific field but show remaining detail

Re: Rank or Topn on a specific field but show remaining detail

Re: Rank or Topn on a specific field but show remaining detail

Re: Rank or Topn on a specific field but show remaining detail