在AVERAGEX函数中添加filterX可以得到错误功率BI

你有两张桌子 SUMMARIZE

AVG Closed Claims =
CALCULATE (
    AVERAGEX (
        SUMMARIZE (
            FILTER ( fact_Loss, fact_Loss[ClosedMMYY] <> BLANK () ),
            -- Remove this one => fact_Loss,
            fact_Loss[ClosedMMYY],
            "Average", COUNT ( fact_Loss[ClaimID] )
        ),
        [Average]
    )
)

在上面,你不需要 CALCULATE . 如果你使用 ,然后这样写:

AVG Closed Claims =
CALCULATE (
    AVERAGEX (
        SUMMARIZE (
            fact_Loss,
            fact_Loss[ClosedMMYY],
            "Average", COUNT ( fact_Loss[ClaimID] )
        ),
        [Average]
    ),
    fact_Loss[ClosedMMYY] <> BLANK ()
)

否则:

AVG Closed Claims =
AVERAGEX (
    SUMMARIZE (
        FILTER ( fact_Loss, fact_Loss[ClosedMMYY] <> BLANK () ),
        fact_Loss[ClosedMMYY],
        "Average", COUNT ( fact_Loss[ClaimID] )
    ),
    [Average]
)

计算 布尔滤波器 这些列过滤上下文,而不仅仅是添加另一个条件。