Forum Discussion

amtbew's avatar
amtbew
Icon for Helper I rankHelper I
2 years ago
Solved

Displaying Rankx Results as Matrix

I have a simple RankX that sorts proposals by the lowest cost. 

 

 

Looking to convert the above to a matrix that would look like this-

 

I believe I'll need a disconnected table to link the column header (bid Rank 1, 2...etc) to the rankx results. I've tried a few things but wasn't able to get it to work. 

 

Here's the pbix with sample data and the existing measures.

https://www.dropbox.com/scl/fi/tfoqsdrqcs5d0xgi7l8pj/RankMatrix.pbix?rlkey=1knpfbz9wjqm0ku3jyuii56vb&dl=0

 

Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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!