Column with Multiple Conditions

[VitaminSea]

Hello,

I have made a table with 3 criteria which indicate Customers:

YOY Sales, % – if it <-20%, then Customer is not reliable;

Paid on Time, % – if it <70%, then Customer is not reliable;

Average Sales per Year – if it <5000 EUR, then Customer is not reliable. 

According to that, green bubble marks reliable, red – not reliable Customers in each criteria. 

Now I need to create a column which would group these Customers according to criteria: 

If there are all 3 green bubbles (non of criteria was achieved), then Customer is Good.

If there are 1 red bubble (one criteria was achieved), then Customer is Average.

If there are >1 red bubbles (two or all three criteria were achieved), then Customer is Bad.

Can someone bring the ideas how could I do that? My vision is to make three buttons (with ChicletSlicer) with Good, Average and Bad categories and like that sort Customers out. 

Thank you in advance. 

[amitchandak · Accepted solution]

@VitaminSea , Create a measure like

Switch ( True(),
[YOY Sales] >= -.20 && [Paid on Time] >= .7 && [Average Sales per Year] >=5000 , "Good",
[YOY Sales] < -.20 && [Paid on Time] < .7 && [Average Sales per Year] <5000 , "Bad",
"Average"
)

But this can not be used as slicer. For slicer, you have to create an independent table with these 3 values.  And filter in a new measure with values(Table[customer no]). Refer this to segmentation video https://www.youtube.com/watch?v=CuczXPj0N-k

[VitaminSea]

EDIT -----------

I managed to get slicer with those 3 values. 🙂

@amitchandak, I watched your video, thank you.

But do not understand, how can I build a table with my 3 values which contain different meanings from different columns?

I mean in your video there is clear one-column data with one meaning of numbers. In my case, there are 3 different meanings of numbers and how can I join all of these into two columns named Start and End Limits?