Help with Summarize or an alternative to it

[arnomics]

Hi all,

I am stuck trying to make a Measure work but been having issues with it. 

In the below measure I am trying to identify $ value based on certain conditions. I've come up with the below which works fine when I have handful of dates selected. Basically it returns $ value based on the date. 

But when I have more than 10 dates on the visual, it runs into the memory error " Visual has exceeded available resources".

I'm gusessing the SUMMARIZE is causing this issue.  I am stuck as of now and unable to move forward. I was hoping someone could help with this. Not sure what other approach I could use, if I did not want to SUMMARIZE perhaps. 

Thanks in advance.

Conditional Value $ =
VAR QualifyingAccountIDs =
    FILTER ( 'Account', [Opening Value ($)] + [Today Value ($)] <> 0 )
VAR _CalTableAcct =
    CALCULATETABLE (
        SUMMARIZE (
            QualifyingAccountIDs,
            'Account'[Account Id],
            "Category1", [Category 1 - Cancelled ($)],
            "Category2", [Category 2 - Cancelled ($)],
            "TODAY", [Today Value ($)],
            "OPENING", [Opening Value ($)]
        ),
        REMOVEFILTERS ( 'Sales' )
    )
RETURN
    SUMX (
        _CalTableAcct,
        IF ( [OPENING] <> 0 && [TODAY] = 0, [Category1] + [Category2], 0 )
    )

[some_bih]

Hi @arnomics try to summarize it firtly then use FILTER

[some_bih]

Hi @arnomics 

part below in really working? Do you get results?

FILTER ( 'Account', [Opening Value ($)] + [Today Value ($)] <> 0 )

[arnomics]

@some_bih  I looked it up through DAX Studio & can confirm it returns a Filtered table with all columns from 'Account'