Different Banding for Different complexity

[addepallibabu]

Hi forum,

I am working on a employee performance report. Usually the employee task complexity divided to three major categories like Easy, Average and Hard. For every complexity we give banding based on accuracy limits as per below table. Now I need to map this to my main fact table column "Complexity" and need to give banding to each employee. I will put a slicer based on complexity and banding should take as per complexity and accuracy limits.

Band	Complexity	Lower Limit	Upper Limit
Band 1	Easy	0.885	1
Band 2	Easy	0.881	0.885
Band 3	Easy	0.8	0.881
Band 4	Easy	0.7	0.8
Band 5	Easy	0	0.7
Band 1	Average	0.744	1
Band 2	Average	0.728	744
Band 3	Average	0.7	0.728
Band 4	Average	0.5	0.7
Band 5	Average	0	0.5
Band 1	Hard	0.543	1
Band 2	Hard	0.529	0.543
Band 3	Hard	0.4	0.529
Band 4	Hard	0.3	0.4
Band 5	Hard	0	0.3

<thead>
</thead><tbody>
</tbody>

Kindly help me in this regard.

Regards,
addepallibabu