PowerBI中使用Switch度量值划分客户收入桶如何避免重叠？

问题根源在于后续桶的条件未排除高优先级桶已满足的情况，导致逻辑存在重叠判断。即使SWITCH按顺序匹配，若后续条件本身仍为TRUE，在部分上下文场景下可能出现错误匹配。修改后的代码会为每个低优先级桶添加前置判断，确保仅在高优先级条件不满足时才进入下一层判断：

Customer Bucket = 
SWITCH(
    TRUE(),
    -- 优先级1：2G/3G任一增长
    OR([2G Revenue Trend] = "Increasing", [3G Revenue Trend] = "Increasing"), 
    "2G/3G Increasing",

    -- 优先级2：2G/3G无增长但有下降，且4G/5G任一增长
    AND(
        NOT(OR([2G Revenue Trend] = "Increasing", [3G Revenue Trend] = "Increasing")),
        OR([2G Revenue Trend] = "Decreasing", [3G Revenue Trend] = "Decreasing"),
        OR([4G Revenue Trend] = "Increasing", [5G Revenue Trend] = "Increasing")
    ), 
    "2G/3G Decreasing, 4G/5G Increasing",

    -- 优先级3：2G/3G无增长但有下降，且4G/5G任一下降
    AND(
        NOT(OR([2G Revenue Trend] = "Increasing", [3G Revenue Trend] = "Increasing")),
        OR([2G Revenue Trend] = "Decreasing", [3G Revenue Trend] = "Decreasing"),
        OR([4G Revenue Trend] = "Decreasing", [5G Revenue Trend] = "Decreasing")
    ), 
    "2G/3G and 4G/5G Decreasing",

    -- 优先级4：2G/3G无增长但有下降，且4G/5G均停滞
    AND(
        NOT(OR([2G Revenue Trend] = "Increasing", [3G Revenue Trend] = "Increasing")),
        OR([2G Revenue Trend] = "Decreasing", [3G Revenue Trend] = "Decreasing"),
        AND([4G Revenue Trend] = "Stagnant", [5G Revenue Trend] = "Stagnant")
    ), 
    "2G/3G Decreasing, 4G/5G Stagnant",

    -- 默认分类
    "Unclassified"
)

关键修改点 #

• 为每个后续桶添加NOT(OR([2G Revenue Trend] = "Increasing", [3G Revenue Trend] = "Increasing"))，确保只有在不满足最高优先级桶的情况下才会判断后续条件
• 严格按优先级顺序执行判断，一旦匹配到符合条件的桶，就会终止后续判断，彻底避免重叠分类

内容的提问来源于stack exchange，提问作者Sarah Bennet