Count price position in PowerBI

To achieve your requirement, you can try this calculated column:

Price Ranking =
RANKX (
    FILTER ( 'Rank', 'Rank'[Product] = EARLIER ( 'Rank'[Product] ) ),
    'Rank'[Price],
    ,
    ASC
)

Thanks,
Xi Jin.

This works perfectly, thanks! What does the EARLIER function do in this context?

Helpful resources

Announcements

Kudos to you if you earned one of these! Check your inbox for a notification.

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Find out where you can attend!