How to analyse data using multiple criteria and output a TEXT result based on the results

[Epidot]

Would appreciate some help on this please.

I have a lot of data set up already. The below output is a table and filtered by 'Year/Month' and 'Name' of the person.

Four different Tables (Tickets Worked,Ticket Updates,Phone Calls and Incident Reviews)

The table totals will change based on the person i select in a name slicer and the months i select.

The Last 6 Month totals in green are just total counts of the selected months added up and displayed in a Card widget, however Incident Reviews is an average instead of count.

What I now need to do is assign KPI levels to the 6 Month Totals 

KPI Levels

Level 0 

Level 1

Level 2

Level 3

These Levels are determined based on More than and Less than.  Each Table has a different criteria range of numbers.

Example for Ticket Updates

Once I have a KPI Level for each, I need to get the average of the 4 results out of "3". I.E Level (1+2+1+3)/4 = 1.75

This is kind of how i want it to look to give you an idea what im trying top acheive.

I just dont know how to get these levels based on the data.

Part of the issue is that the table data isnt by year/month. 

I thought i could add a column to get the count of rows for a given person for the given month and then use that number to apply criteria to and get a level from it. But as there are rows for many days in the month, each row gets given a value and then the table sums all the rows for the month giving me the correct number but X30 days.

example of data set for tickets updates. some data greyed out

Thanks

[amitchandak]

@Epidot , I think you need segmentation on measure

few examples

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY

[Epidot]

Thank you i will take a look at these.