DAX中SELECTEDVALUE失效，IN STORE分支计算结果异常求助

问题背景 #

原DAX代码运行正常，添加判断分支类型为IN STORE时执行SUMX汇总计算的逻辑后，返回结果不符合预期。

现有代码：

totalAverageBaysFinalVersion =
VAR onlyCampaignFiltered =
    ISFILTERED ( 'Campaign Overview'[campaign] )
        && NOT CALCULATE (
            ISCROSSFILTERED ( 'range_plans' ),
            REMOVEFILTERS ( 'Campaign Overview'[campaign] )
        )
            || ISFILTERED ( 'Calendar'[weekNumWeekCommence] )
RETURN
    SWITCH (
        TRUE (),
        SELECTEDVALUE ( 'Campaign Overview'[branch_type] ) = "IN STORE", --Additional Code
            SUMX (
                SUMMARIZE (
                    range_plans,
                    range_plans[branch],
                    range_plans[range_name],
                    range_plans[number_bays]
                ),
                range_plans[number_bays]
            ),
        IF (
            onlyCampaignFiltered,
            SUMX (
                SUMMARIZE (
                    range_plans,
                    range_plans[branch],
                    range_plans[range_name],
                    range_plans[number_bays]
                ),
                range_plans[number_bays]
            ),
            [Total Avg Bays Campaign Overview]
        )
    )

期望输出 #

问题原因与修复方案 #

核心问题 #

1. SELECTEDVALUE仅在单值筛选时生效，当报表同时显示IN STORE和ONLINE多行数据时，会返回空白，导致第一个SWITCH条件无法触发。
2. IN STORE分支的SUMX未关联Campaign Overview的分支类型筛选，计算的是全部分支的bays总和，而非仅IN STORE对应的数据。

修复后的代码 #

totalAverageBaysFinalVersion =
VAR onlyCampaignFiltered =
    ISFILTERED ( 'Campaign Overview'[campaign] )
        && NOT CALCULATE (
            ISCROSSFILTERED ( 'range_plans' ),
            REMOVEFILTERS ( 'Campaign Overview'[campaign] )
        )
            || ISFILTERED ( 'Calendar'[weekNumWeekCommence] )
RETURN
    SWITCH (
        TRUE (),
        -- 直接使用行上下文的分支类型判断，适配多行列展示场景
        'Campaign Overview'[branch_type] = "IN STORE",
            SUMX (
                SUMMARIZE (
                    -- 筛选出当前分支类型对应的range_plans记录
                    FILTER(range_plans, RELATED('Campaign Overview'[branch_type]) = "IN STORE"),
                    range_plans[branch],
                    range_plans[range_name],
                    range_plans[number_bays]
                ),
                range_plans[number_bays]
            ),
        -- 明确ONLINE分支返回0值
        'Campaign Overview'[branch_type] = "ONLINE",
            0,
        -- 保留原有逻辑处理其他场景
        IF (
            onlyCampaignFiltered,
            SUMX (
                SUMMARIZE (
                    range_plans,
                    range_plans[branch],
                    range_plans[range_name],
                    range_plans[number_bays]
                ),
                range_plans[number_bays]
            ),
            [Total Avg Bays Campaign Overview]
        )
    )

关键调整点 #

1. 替换判断逻辑：用行上下文的'Campaign Overview'[branch_type]替代SELECTEDVALUE，确保每行都能基于自身分支类型执行对应计算。
2. 添加数据筛选：在IN STORE分支的SUMX中，通过FILTER和RELATED关联分支类型，仅计算IN STORE对应的range_plans数据。
3. 明确ONLINE分支返回值：直接指定ONLINE分支返回0，匹配期望输出要求。

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