ranking

[wjenkins3811]

Hello,

I'm trying to find a formula that will rank hundreds of accuracy numbers into 4 tiers. The accuracy numbers you see below are from a measure. I am unable to provide more visuals for security purposes. I've located formulas that use calculated columns but havent found one that included a measure. The rankings will also need to adjust as we load more data and adjust the dates. Thank you.

[v-jiascu-msft · Accepted solution]

Hi @wjenkins3811,

Please share a dummy sample. If you just want to divide them into 4 tiers, how about a formula like below.

Measure =
IF (
    [pre_accuracy] >= 0.75,
    1,
    IF ( [pre_accuracy] >= 0.5, 2, IF ( [pre_accuracy] >= 0.25, 3, 4 ) )
)

Best Regards,

Dale

[Anonymous]

Hi @wjenkins3811

I understand that confident data cant be displayed here, but please type some sample data with your expected output for that sample data & Post here in copy / paste-able format. That will help others to help you.

Thanks

Raj