Forum Discussion

bassmaninaus_PB's avatar
bassmaninaus_PB
Frequent Visitor
4 years ago
Solved

Summarize with Filter not working

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! 

  • VahidDM's avatar
    VahidDM
    4 years ago

    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/

     

     

2 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    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/