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.
Hi All,
I'm trying to write a measure that will give me a specific value based on the result of another measure. I have the following measure "NON-PM Score = DIVIDE([NON-PM On Time], [NON-PM Total])" that gives me a percentage. Based on this percentage I am trying to write a measure that will give me a number 1-5. This is what I was trying to use but it doesnt not work:
What I basically need is for the measure for show a
5: 95% and higher
4: 90 - 94.9%
3: 80 - 89.9%
2: 70 - 79.9%
1: anything less than 70%
Thank you in advance!
@am_i_really Hard to say why it isn't working. You could simplify it and get better performance this way. Perhaps provide sample data and a description of what is going wrong.
Measure =
VAR __Measure = 'Measures Table'[NON-PM Score]
SWITCH(
TRUE(),
__Measure < .7, "1",
__Measure > .69 < .80, "2",
__Measure > .79 < .90, "3",
__Measure > .89 < .95, "4",
"5"
)
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |