Forum Discussion

wjenkins3811's avatar
wjenkins3811
Frequent Visitor
8 years ago
Solved

ranking

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.

 

 

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    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