cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

## Sum DAX Measure with Multiple Filters in One Column

Hi,

I am trying to run a sum total to include a filter that only includes specific codes in the flow column.

The below is what I have tried yet the error I get is "Operator or expression '()' is not supported in this context.

Sum of Payment =
CALCULATE(
SUM('Kyriba AGTL'[Ledger amount (value)],
KEEPFILTERS('Kyriba AGTL'[Flow] IN ("-AP", "-ICPAY", "-VAT", "-EXP", "-RENT", "-ICPAYR", "-PAYROLL")
)

Any help is appreciated
1 ACCEPTED SOLUTION
Super User

Please try something like below if it suits your requirement.

``````Sum of Payment =
CALCULATE (
SUM ( 'Kyriba AGTL'[Ledger amount (value)] ),
KEEPFILTERS ( 'Kyriba AGTL'[Flow]
IN { "-AP", "-ICPAY", "-VAT", "-EXP", "-RENT", "-ICPAYR", "-PAYROLL" } )
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

2 REPLIES 2
New Member

This is perfect, thank you so much for your help!

Super User

Please try something like below if it suits your requirement.

``````Sum of Payment =
CALCULATE (
SUM ( 'Kyriba AGTL'[Ledger amount (value)] ),
KEEPFILTERS ( 'Kyriba AGTL'[Flow]
IN { "-AP", "-ICPAY", "-VAT", "-EXP", "-RENT", "-ICPAYR", "-PAYROLL" } )
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page