Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
I believe a similar thread is found at https://community.powerbi.com/t5/Desktop/Sum-of-values-by-each-category/td-p/134279.
Proud to be a Super User!
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
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
I believe a similar thread is found at https://community.powerbi.com/t5/Desktop/Sum-of-values-by-each-category/td-p/134279.
Proud to be a Super User!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |