Forum Discussion

Megadeth's avatar
Megadeth
Frequent Visitor
8 years ago
Solved

Measure with a factor table.

Hi!    I´ve created this table containing all my my processes and corresponding factors. I want to use factors for each process beacuse when im forecasting i tend to see trends changing on process ...
Need Help
  • MattAllington's avatar
    MattAllington
    8 years ago

    I guess it is this. 

     

    ForeCastWithFactors =  SUMX('ProcessFactors'; [forecast] * ‘ProcessFactors'[ProcessFactor])

     

    Maybe even this

     

    ForeCastWithFactors =  SUMX(values('ProcessFactors'[processfactor]); [forecast] * ‘ProcessFactors'[ProcessFactor])

MattAllington's avatar
MattAllington
Community Champion
8 years ago

I guess it is this. 

 

ForeCastWithFactors =  SUMX('ProcessFactors'; [forecast] * ‘ProcessFactors'[ProcessFactor])

 

Maybe even this

 

ForeCastWithFactors =  SUMX(values('ProcessFactors'[processfactor]); [forecast] * ‘ProcessFactors'[ProcessFactor])

Megadeth's avatar
Megadeth
Frequent Visitor
8 years ago

I cannot thank you enough, altough i feel very stupid for that simple sollution :)

 

Thanks again! SUMX('ProcessFactors'; [forecast] * ‘ProcessFactors'[ProcessFactor]) worked like a charm.