Forum Discussion

S_Berg's avatar
S_Berg
Frequent Visitor
3 years ago
Solved

Calculation with multiple filters

I need to calculate: When Payment_Type = 1 AND Service_Type = 1 Then multiple Payment_Type by Year_Rate   When I try: Payment = IF(     AND(         COUNT(FILES_PAYMENT[Service_Type])= 01, ...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, S_Berg 

     

    You can try the following methods.

    Payment = CALCULATE ( SUM ( RATES[Year_Rate] ))
            * CALCULATE ( COUNT ( FILES_PAYMENT[Payment_Type] ),
                FILTER ( ALL ( FILES_PAYMENT ), [Payment_Type] = 1 && [Service_Type] = 1 )
            )

    If that doesn't resolve your issue, provide sample data and expected output.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

tberr86's avatar
tberr86
Frequent Visitor
3 years ago

Try:
Payment= IF(AND(FILES_PAYMENT[Service_Type]= 1,FILES_PAYMENT[Payment_Type]= 1),[Year_Rate]*[Payment_Type])

You may run into errors depending on data type as this function assumes a number data type not a string.