Displaying Rankx Results as Matrix

Hi amtbew ,

Please try to create a calculated column:

Rank = RANKX(
    FILTER(
        'Bids',
        'Bids'[Product] = EARLIER('Bids'[Product])
    ),
    'Bids'[Proposal],
    ,
    1
)

Enter the relevant number for Rank via Enter Data.

Build relationships.

Use the matrix visual:

Drag Product to the row, Bid Rank to the column, and Proposal and Vendor to values.

Or do you like this?

pbix file is attached.

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!