DAX查询中的性能增强

Question

我有一个度量中使用的Power查询。执行起来需要更长的时间。有人能帮我吗？

MEASURE FACT_CONSOL_BALANCE_OL[Measure 4] =
    SWITCH (
        TRUE (),
        CONTAINS (
            DIM_ANALYTIC_STRUCT_ACCOUNT,
            DIM_ANALYTIC_STRUCT_ACCOUNT[STRUCTURE_NODE (groups)], "1 - CURRENT ASSETS"
        ), SUM ( FACT_CONSOL_BALANCE_OL[BALANCE] ),
        CONTAINS (
            DIM_ANALYTIC_STRUCT_ACCOUNT,
            DIM_ANALYTIC_STRUCT_ACCOUNT[STRUCTURE_NODE (groups)], "2 - NON - CURRENT ASSETS"
        ), SUM ( FACT_CONSOL_BALANCE_OL[BALANCE] ),
        SUM ( FACT_CONSOL_BALANCE_OL[BALANCE] ) * -1
    )

DAX上的性能结果：

​

​

Answer 1

请您试试这段代码，看看它是否解决了您的问题。我试图在没有write ()函数的情况下编写它。

MEASURE FACT_CONSOL_BALANCE_OL[Measure 4] =
    SUMX (
        FACT_CONSOL_BALANCE_OL,
        VAR Balance =
            SWITCH (
                RELATED ( DIM_ANALYTIC_STRUCT_ACCOUNT[STRUCTURE_NODE (groups)] ),
                "1 - CURRENT ASSETS", FACT_CONSOL_BALANCE_OL[BALANCE],
                "2 - NON - CURRENT ASSETS", FACT_CONSOL_BALANCE_OL[BALANCE],
                FACT_CONSOL_BALANCE_OL[BALANCE] * -1
            )
        RETURN
            Balance
    )