Break ranking ties in a calculated column!

Power BI
1

Hello team,

I want to break ties in a calculated column but I am not sure how it will work. I have created a ranking column and when “MW Loss” is same, I get multiple values. In case of same “MW Values”, I want to break ties by the Block. Is it possible. Snapshot and PBI file is attached below:

image
image1188×787 65.4 KB

PBI ranking test !!.pbix (23.2 KB)

Regards,
Naila

2

Hi @Naila

You could try the new RANK function, which works similar to windows functions in SQL if you’re familiar with those:

Ranking 2 = 
RANK(
    DENSE,
    ,
    ORDERBY( Data[MW Loss], DESC, Data[Block], DESC)
)

Changing the last DESC to ASC will change which order it uses the Block column as required.

PBI ranking test !!.pbix (23.7 KB)

1 Like
3

Hello @Naila

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

4

Hi @jamie.bryan ,

Thank you for providing the solution. This is the exact solution I was looking for.

Thanks again !!

Regards,
Naila