Multiply value in each row with the total number from another column

[birgirs]

hi guys 

need some Dax help

i need to multiply col1 with the total numer from col2(130) and show that in col3  

col1 col2  col3

0,1   20      0,1*130

0,2   30      0,2*130

0,4   50      0,4*130

0,1   10      0,1*130

0,2   20      0,2*130    

[Interkoubess]

Hi @birgirs,

Please try this formula in a calcultaed field ( I called my table Table1):

[Col1]*CALCULATE(SUMX(Table1,[Col2]),ALL(Table1))

Hope it helps...

Ninter

[birgirs]

no that did not work 

there are more columns 

and if i want to filter by "kiwi" then it is multiplying all of col3 (260) but i only want total for the selected filter 

col1 col2  col3        col4

0,1   20      0,1*130  apples

0,2   30      0,2*130  apples

0,4   50      0,4*130  apples

0,1   10      0,1*130  apples

0,2   20      0,2*130  apples

0,1   20      0,1*130  Kiwi

0,2   30      0,2*130  Kiwi

0,4   50      0,4*130  Kiwi

0,1   10      0,1*130  Kiwi

0,2   20      0,2*130  Kiwi

[ChrisMendoza · Accepted solution]

@birgirs, 

I believe a similar thread is found at https://community.powerbi.com/t5/Desktop/Sum-of-values-by-each-category/td-p/134279.