New column with if condition and filter

[ManjunathaEP]

Hi, Please help to create a new column for the below sample:

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

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

"Flex" should be the customers have orders for both "Y/N" in Y/N? column

"Nonflex" should be the customers are not having orders either by Y or N in the Y/N? column

Thank you in advance

[amitchandak]

@ManjunathaEP , Try a new column like

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

[ManjunathaEP]

• Hi, Thank you for the response, the given DAX is calculated flex and non flex by customer name.
• I hope, I have not explained correctly in my 1st message, 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