Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Measure showing blank

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

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

2 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    9 years ago

    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's avatar
      Anonymous
      Not applicable
      9 years ago

      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