Entiteit = PayrollResults Type = Meting Voorbeeld: Optellen waardes van uitvoercodes 1001 en 1002 CALCULATE(SUM('PayrollResults'[PayrollResult]), (('PayrollResults'[PayrollCode_BK]) = 1001 ) + (('PayrollResults'[PayrollCode_BK]) = 1002 ) ) Wil je een code negatief tellen: CALCULATE(SUM('PayrollResults'[PayrollResult]) * -1, (('PayrollResults'[PayrollCode_BK]) = 1001 ) + (('PayrollResults'[PayrollCode_BK]) = 1002 ) ) Combinatie van beide: CALCULATE(SUM('PayrollResults'[PayrollResult]), (('PayrollResults'[PayrollCode_BK]) = 1001 ) + (('PayrollResults'[PayrollCode_BK]) = 1002 ) ) + CALCULATE(SUM('PayrollResults'[PayrollResult]) * -1, (('PayrollResults'[PayrollCode_BK]) = 1001 ) + (('PayrollResults'[PayrollCode_BK]) = 1002 ) )
... View more