topic Re: Sum DAX Measure with Multiple Filters in One Column in DAX Commands and Tips

Sum DAX Measure with Multiple Filters in One Column

ChantelleP — Thu, 22 Feb 2024 17:17:35 GMT

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

Re: Sum DAX Measure with Multiple Filters in One Column

Jihwan_Kim — Thu, 22 Feb 2024 17:45:19 GMT

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" } ) )

Re: Sum DAX Measure with Multiple Filters in One Column

ChantelleP — Fri, 23 Feb 2024 13:45:27 GMT

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