Forum Discussion
Solved
The MAX function only accepts a column reference as the argument number 1.
top 80% contributor in error = IF('table'[L1 Reason] = "NA","NA",IF(MAX([measure1]) <= 80,"YES",(IF(MAX([measure2]) <= 80,"YES","NO"))))
jay_patel , You can use measure in MAXX, But if you are trying to create a new column here, this will not work
you have to create a new measure like
IF(max('table'[L1 Reason]) = "NA","NA",IF(MAXX(Table,[measure1]) <= 80,"YES",(IF(MAXX(Table,[measure2]) <= 80,"YES","NO"))))
jay_patel , You can use measure in MAXX, But if you are trying to create a new column here, this will not work
you have to create a new measure like
IF(max('table'[L1 Reason]) = "NA","NA",IF(MAXX(Table,[measure1]) <= 80,"YES",(IF(MAXX(Table,[measure2]) <= 80,"YES","NO"))))