If Measures Statements

[otl_86]

I have made measures to produce the table below to contail hours filled, hours needed and percentage of hours used.

On the table below i would like to add another column for when the percentage is in a certain range for ti to be categorised as a level.

E.g 

Level 1	90%-100%
Level 2	80%-89%
Level 3	70%-79%
Level 4	00%-69%
Service re-direction if overall shift fill rate falls below 40%	<40%

How would I go about doing this.  I have done them as a coloumn but unable to show in the table.

Thanks

[v-jingzhang · Accepted solution]

Hi @otl_86 

As your [% Hours] is a measure, you can create a measure to get the categorised level. For example

Level =
SWITCH (
    TRUE (),
    [% Hours] > 0.9, "Level 1",
    [% Hours] > 0.8, "Level 2",
    [% Hours] > 0.7, "Level 3",
    [% Hours] > 0.6, "Level 4",
    [% Hours] > 0.5, "Level 5",
    [% Hours] > 0.4, "Level 6",
    "Level 7"
)

If it is not what you want, please describe the output result you want based on some sample data. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Vijay_A_Verma]

Is your level 4 ranges from 40% to 70% otherwise service redirection would not be applicable?