Summarize with Filter not working

[bassmaninaus_PB]

Hi, I'm trying to do two conditions with creating a new table.

What I have so far is..

KeyClients>500 = 
CALCULATETABLE( 
    SUMMARIZE(
        KeyClientData
            ,KeyClientData[Region] 
            ,KeyClientData[Product]
            ,KeyClientData[CompanyCode]
            ,"ACDCalls", SUM(KeyClientData[ACDCalls])
        ),
        FILTER(
            KeyClientData
                ,KeyClientData[LastMonth] = 1 &&
                sum(KeyClientData[ACDCalls])>500)
)

The condition of LastMonth = 1 is working however it's bringing back ACDCalls under 500.

Can anyone see a simple fix?

Thanks in advance! 

[bassmaninaus_PB]

Magic! Thanks VahidDM!

[VahidDM · Accepted solution]

Hi @bassmaninaus_PB 

Try this:

KeyClients>500 =
FILTER(
    CALCULATETABLE(
        SUMMARIZE(
            KeyClientData,
            KeyClientData[Region],
            KeyClientData[Product],
            KeyClientData[CompanyCode],
            "ACDCalls Sum", SUM( KeyClientData[ACDCalls] )
        ),
        FILTER( KeyClientData, KeyClientData[LastMonth] = 1 )
    ),
    [ACDCalls Sum] > 500
)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/