Forum Discussion

ChantelleP's avatar
ChantelleP
New Member
2 years ago
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 '()' ...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    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" } )
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
2 years ago

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