topic Summarize with Filter not working in DAX Commands and Tips

Summarize with Filter not working

bassmaninaus_PB — Sat, 26 Feb 2022 05:07:55 GMT

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!

Re: Summarize with Filter not working

VahidDM — Sat, 26 Feb 2022 07:14:14 GMT

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/

Re: Summarize with Filter not working

bassmaninaus_PB — Sat, 26 Feb 2022 08:15:51 GMT

Magic! Thanks VahidDM!