Forum Discussion
Solved
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 '()' ...
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" } ) )
This is perfect, thank you so much for your help!