RapidMiner条件赋值语法错误排查：结果全显Highest异常

错误根源 #

原代码中的max([New member growth rate (%)])是行上下文计算，它只会返回当前行的增长率数值，而非整个数据集的全局最大值。这就导致所有非0的行都会满足[New member growth rate (%)] == max(...)的判断条件，最终全部显示为"Highest"。

修复代码 #

根据你使用的工具，选择对应的修正方案：

Power BI（DAX） #

用CALCULATE函数强制计算全局最大值：

IF(
    [New member growth rate (%)] == 0, 
    "Lowest", 
    IF(
        [New member growth rate (%)] == CALCULATE(MAX([New member growth rate (%)])), 
        "Highest", 
        "Intermediate"
    )
)

Tableau #

用固定集计算全局最大值：

IF [New member growth rate (%)] = 0 THEN "Lowest"
ELSEIF [New member growth rate (%)] = {FIXED : MAX([New member growth rate (%)])} THEN "Highest"
ELSE "Intermediate"
END

内容的提问来源于stack exchange，提问作者Yik Wei