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.
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
Solved! Go to 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.
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.
Is your level 4 ranges from 40% to 70% otherwise service redirection would not be applicable?
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.