IF function for multiple FILTERS

[ManjunathaEP]

Hi All, I have a requirement to create a new column for the below-given table: Thank you in advance

order No	Cust Name	Y/N?	Revenue class	Amount	New column
111	ABC	Y	Apple	100	Flex
112	XYZ	N	Apple	22	Flex
113	ABC	N	Apple	300	Flex
114	XYZ	Y	Orange	66	Flex
115	DFG	N	Apple	667	NonFlex
116	DDF	Y	Orange	567	NonFlex
112	XYZ	N	Mango	345	Flex
111	ABC	Y	Mango	349	Flex

New column = I want the results as flex or nonflex. 

• The actual requirement is to link flex or non flex for each row based on the "distinct" order number and distinct customer name by column name Y/N?
• Flex: If column Y/N? equals "Y and N", then it should be Flex for those distinct orders and distinct customers
• NonFlex" If column Y/N? "Y OR N", then it should be NonFlex for those distinct orders and distinct customers  

[rfigtree]

[amitchandak]

@ManjunathaEP , Create a new column like

If(calculate(distinctCOUNT([Y/N?]), filter(Table, [Cust Name] =earlier([Cust Name])))+0=2, "Flex"," NonFlex")