Calculate on each row

[Wresen]

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..

[Tahreem24]

@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]

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

[Wresen · Accepted solution]

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