Forum Discussion

byr10112's avatar
byr10112
Microsoft Employee
3 years ago

Measure with Row Level Calculations

Hello, I am trying to create a measure that will show me the full year forecast. There are 3 variables that go into the calculation. The measure: Forecast = SUM(Revenue[Actuals]) + Sum(Revenue[Sche...
Need Help
jgeddes's avatar
jgeddes
Super User
3 years ago

Can you share what you wrote and the value(s) that are being returned?

byr10112's avatar
byr10112
Microsoft Employee
3 years ago

I copy and pasted your formula and changed the table and field names accordingly. Account 1006 is still showing 0, for some other accounts pipeline and/or actuals are appearing as 0

  • jgeddes's avatar
    jgeddes
    Super User
    3 years ago

    Ok. Let's try and troubleshoot this. 

    If I create a new calculated table with...

    Forecast Table = 
    var _vtable =
    SUMMARIZE(
        accountTable,
        accountTable[Account ID],
        "_Forecast", IF(OR(ISBLANK(SELECTEDVALUE(revenueTable[Actuals]) + SELECTEDVALUE(pipelineTable[Pipeline]) + SELECTEDVALUE(revenueTable[Scheduled Revenue])), SELECTEDVALUE(revenueTable[Actuals]) + SELECTEDVALUE(pipelineTable[Pipeline]) + SELECTEDVALUE(revenueTable[Scheduled Revenue])=0), SELECTEDVALUE(wonPipelineTable[Won Pipeline]), SELECTEDVALUE(revenueTable[Actuals]) + SELECTEDVALUE(pipelineTable[Pipeline]) + SELECTEDVALUE(revenueTable[Scheduled Revenue]))
    )
    Return
    _vtable

    I get...

    If you create a new table with that formula (changing the table/column names to match yours) what table do you get?

    • byr10112's avatar
      byr10112
      Microsoft Employee
      3 years ago

      I tried doing this already. The same thing happened, for 1006 it appeared as 0