Measure showing blank

[Anonymous]

Hi,

I am trying to minus the cost actuals in a measure using

Actuals = if('SageFunctCodes$'[Type]="Cost",-SUM(Transactions[tran]),SUM(Transactions[tran]))

However when I put that measure onto the table it shows 0.00

Any ideas?

Thanks

[BhaveshPatel]

The approach you are taking is completely wrong. Can you please elaborate your issue and post the sample data if possible.

"I am trying to minus the cost actuals".??

Are you trying to put a minus sign in front of the "cost "??

[Anonymous · Accepted solution]

Thanks lol,

Sage has the revenue as minus and costs as positive, I am trying to reverse this in PowerBI, I could do it in SQL but was looking for a measure to do it.

Just thinking I could do Actual = Sum(actual) * -1

Thanks

Chris