Difficult Ranking and Filtering Problem

[Adam_Swift]

Hi, 

I have a problem filtering a table into all bids for the auctionpropertyid of the current row and then ordering Disitinct auctionbidderID's into the order they bid in (ie. this was the first bidder, this was the second bidder, this was the third bidder ect... ) (* the goal is not to order the bids for a properrty I have that already) and then returing the order number for that bidder in the row that is currentley being evaluated in auction bidding transaction table. 

1. What I'm trying to do is filter the table by auctionpropertyId (to get all bids made on this property).

2. Order the bids from 1,2...n ( I do have a calculated Column for this).

3. Find the first bids from each bidder (auctionbidderID) an return the order that bidder joined the bidding. 

  - So if he made the 10th bid but was the 3rd unique bidder is needs to return 3. 

 - I can filter a table with all the bids for that property but cant solve how to the order/filter the filtered table agian to include the       first bid form each unique bidder and the order they bid in and retunn that value for the specifc bidder in current row. 

4. Every row in this table has a bidderId, auctionpropertyid etc... 

Any help would be appreciated

Cheers 

Adam 

[dax]

Hi Adam_Swift,

I can't reprocedure your design based on your description, so if possible, could you please inform me more detailed information(such as your data sample and your expecting output)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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