COUNTAX FILTER SUMMARIZE-条件计数

COUNTAX+FILTER+SUMMARIZE

=
CALCULATE(
    COUNTAX(
        FILTER(
            SUMMARIZE(
                '事实_订单业绩明细',
                '事实_订单业绩明细'[订单.ID],
                '事实_订单业绩明细'[订单.类型],
                '事实_订单业绩明细'[订单.完款日期],
                "是否完款",
                    AND(
                        [订单.完款日期]>DATE(2000,1,1),
                        AND(
                            ([订单.类型]<>"营销订单"),
                            [团队_收款_金额]>700
                        )
                    )
            ),
            [是否完款]=TRUE()
        ),
        [订单.ID]),
    USERELATIONSHIP(
        '维度_日期'[日期],
        '事实_订单业绩明细'[订单.完款日期]
    )
)