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] ...
  • 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/

     

     

VahidDM's avatar
VahidDM
Icon for Super User rankSuper 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/