Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |