Forum Discussion

LLT1021's avatar
LLT1021
Helper I
3 years ago

SUMX

Dear all,   I have a question regarding SUMX in relation with memory issues.  I made a small table in which is displayed amount A, an amount B and C=MAX(A-B,0) for key users of a system. These ...
Need Help
LLT1021's avatar
LLT1021
Helper I
3 years ago

There are 3150 records in that table.

JirkaZ's avatar
JirkaZ
Solution Specialist
3 years ago

That's not too much to be honest. Your formula should work just fine. Is it failing on the Desktop or in the service as well? 

  • LLT1021's avatar
    LLT1021
    Helper I
    3 years ago

    Hmm ok, I just tried also in service and it gives the same problem unfortunately - the visual has exceed the available resources.. 

    • JirkaZ's avatar
      JirkaZ
      Solution Specialist
      3 years ago

      Might be related to how the measures A and B are defined then.

      • LLT1021's avatar
        LLT1021
        Helper I
        3 years ago

        A = 

        CALCULATE (
            SUM ( 'Fact'[Hours] ),
            'Fact'[Soort] <> "Niet toegewezen"
                           )

        B = divide( 
        CALCULATE (
            TOTALYTD ( SUM ( 'Fact'[Start right] ), Datumtabel[Datum] ),
            'Fact'[soort] = "AV"
        ),
        12
        )