Forum Discussion
Column with Multiple Conditions
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.
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
2 Replies
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
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?
