Column Based on Values From a Measure

Hi
All,

Need your help!!

I have Matrix report with the employee total score split by categories and need to add a calculated column based on the measure value. This measure comes from the selection of the slicers.

For Example Table: The Required score is calculated measure and below Pivot table have Total Score by each employee

I need to add a dynamic column to check each employee total score with the required score and work out whether that employee will have "full access" or "partial access".

Thank you in advance for your help!