Forum Discussion

Wresen's avatar
Wresen
Post Patron
3 years ago
Solved

Calculate on each row

Hi and thx for reading this.

 

I have a simple problem i belive but i cant get it to work as i want.
I have a table like below:

I want to have a measure that multiplys each rows "Sum of Value" with "Proc Value.
I want to be able to remove all columns except Month and measure to get a resulat like:

 

Thanks so much for any help..

Need Help
  • Wresen's avatar
    Wresen
    3 years ago

    I think i have found a solution: (maybe not the best but i seems to work)

    Measure  = var _proc  = CALCULATE(sum(Sheet1[Proc]),filter((Sheet1),Sheet1[Proc] <> BLANK()))
    var _value = CALCULATE(sum(Sheet1[value]),filter((Sheet1),Sheet1[Proc] <> BLANK()))
    Var div = _proc/_value
    return
    div * _value

3 Replies

  • Wresen's avatar
    Wresen
    Post Patron
    3 years ago

    I think i have found a solution: (maybe not the best but i seems to work)

    Measure  = var _proc  = CALCULATE(sum(Sheet1[Proc]),filter((Sheet1),Sheet1[Proc] <> BLANK()))
    var _value = CALCULATE(sum(Sheet1[value]),filter((Sheet1),Sheet1[Proc] <> BLANK()))
    Var div = _proc/_value
    return
    div * _value
  • Tahreem24's avatar
    Tahreem24
    Super User
    3 years ago

    Wresen  TRy this measure: 

    Measure = IF(BLANK(Proc Value), Blank(), SUM(Values) * SUM(Proc Value))

    Then take this Month and  Measure in a table.

    • Wresen's avatar
      Wresen
      Post Patron
      3 years ago

      Hi Tahreem24 
      Thanks for your reply, but I am sorry but i dont get that mesure to work at all.