Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |