How to reference ifs in DAX

[Anonymous]

I need to say

AVB = IF('SageFunctCodes$'[type]="Cost",Budgets[Budget]-Transactions[Actual],IF('SageFunctCodes$'[Type]="Revenue",Transactions[Actual]-Budgets[Budget],0))

but in a measure.  When I try to copy the code in the measure it does not recognise the SageFunctCodes columns.  How would I go about replicating the above in a Dax measure.

Thanks

C

[Anonymous · Accepted solution]

Found 

AvB = IF(COUNTROWS(VALUES( 'SageFunctCodes$'[Type] ))=1, 
        IF(VALUES( 'SageFunctCodes$'[Type] ) =  "Cost", 
         Budgets[Budget]-Transactions[Actual], 
         IF(VALUES( 'SageFunctCodes$'[Type] ) =  "Revenue", 
         Transactions[Actual]-Budgets[Budget]) ),Transactions[Actual]-Budgets[Budget])

This works.