Forum Discussion

6 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Analitika , not too bad in my case. The first matrix is slow. All values of the measure are the same. Is it expected or some measure problem

    • Analitika's avatar
      Analitika
      Icon for Post Prodigy rankPost Prodigy
      6 years ago

      It only 2 customer of 100.000  on original version not loading at all, problem with m_SSA_3 measure. I have no idea how to make it work

      • edhans's avatar
        edhans
        Icon for Community Champion rankCommunity Champion
        6 years ago

        The problem is this M_SSA_3 measure:

        m_SSA_3 =
VAR valText1 = [ABC_LIKUČIAI_1]
VAR valText12 = [ABC_LIKUČIAI_2]
VAR Result =
    CALCULATE(
        CALCULATE(
            CALCULATE(
                SUM( Table1[OPE_SUMOL] ),
                FILTER(
                    Table1,
                    Table1[OP_ATS]
                        IN {
                        0
                    }
                        && NOT Table1[OP_VIE] = 3
                        && NOT Table1[ZU0_KOD]
                        IN {
                        valText1,
                        valText12
                    }
                )
            ),
            FILTER(
                ALL( 'Date'[Date] ),
                'Date'[Date]
                    <= MAX( 'Date'[Date] )
            )
        )
            - CALCULATE(
                CALCULATE(
                    SUM( Table1[OPE_SUMOL] ),
                    FILTER(
                        Table1,
                        Table1[OP_ATS]
                            IN {
                            0
                        }
                            && Table1[OP_VIE] = 3
                            && NOT Table1[ZU0_KOD]
                            IN {
                            valText1,
                            valText12
                        }
                    )
                ),
                FILTER(
                    ALL( 'Date'[Date] ),
                    'Date'[Date]
                        <= MAX( 'Date'[Date] )
                )
            )
            - CALCULATE(
                CALCULATE(
                    SUM( Table1[OPE_SUMOL] ),
                    FILTER(
                        Table1,
                        Table1[OP_ATS]
                            IN {
                            2
                        }
                            && NOT Table1[ZU0_KOD]
                            IN {
                            valText1,
                            valText12
                        }
                    )
                ),
                FILTER(
                    ALL( 'Date'[Date] ),
                    'Date'[Date]
                        <= MAX( 'Date'[Date] )
                )
            )
            - CALCULATE(
                CALCULATE(
                    SUM( Table1[OPE_SUMOL] ),
                    FILTER(
                        Table1,
                        Table1[OP_ATS]
                            IN {
                            0
                        }
                            && Table1[ZU0_KOD]
                            IN {
                            valText1,
                            valText12
                        }
                            && Table1[_MZA2] > 0
                    )
                ),
                FILTER(
                    ALL( 'Date'[Date] ),
                    'Date'[Date]
                        <= MAX( 'Date'[Date] )
                )
            )
            - CALCULATE(
                CALCULATE(
                    SUM( Table1[OPE_SUMOL] ),
                    FILTER(
                        Table1,
                        Table1[OP_ATS]
                            IN {
                            0
                        }
                            && Table1[ZU0_KOD]
                            IN {
                            valText1,
                            valText12
                        }
                            && Table1[_MZA2] < 0
                    )
                ),
                FILTER(
                    ALL( 'Date'[Date] ),
                    'Date'[Date]
                        <= MAX( 'Date'[Date] )
                )
            ),
        FILTER(
            Table2,
            Table2[SK/AV] = "IAT"
        )
    )
RETURN
    /*IF (
       "PREK_G" IN DISTINCT ( Table1[rus_kod] )|| "NUOLAI" IN DISTINCT ( Table1[rus_kod] ), Result, -Result 
    )*/
    IF(
        SELECTEDVALUE( Table1[rus_kod] ) = "PREK_G"
            || SELECTEDVALUE( Table1[rus_kod] ) = "NUOLAI",
        Result,
        - Result
    )

        And the M_SSA_4 is only slightly better. Those nested CALCULATES are doing all sorts of context transitions and reitterating over the tables. That needs to be totally reworked, and it needs to be scoped out as to what it is trying to do.