Forum Discussion
dax divide multiple columns
Hello, I would like to create a column Result. I wrote formulas into the column.
| Source | Price (col B) | Profit (col C) | Result |
| 2000 | 5000 | 108,70% (=C2/$C$6/(B2/$B$6)) | |
| Bing | 3000 | 6000 | 86,96% |
| 2500 | 7000 | 121,74% | |
| 2500 | 5000 | 86,96% | |
| Total | 10000 | 23000 | 100,00% (=C6/$C$6/(B6/$B$6)) |
Thanks for the advice
Tomas
Anonymous ,
Please refer a screen shot attached:
4 Replies
Anonymous ,
Please refer a screen shot attached:
Anonymous , as a new column in the table
[Price (col B)]/sum([Price (col B)])/ [Profit (col C)] /sum( [Profit (col C)])
or as a new measure
sum(Table[Price (col B)])/calculate(sum([Price (col B)]),all(Table))/ sum(Table[Profit (col C)]) /calculate(sum(Table[Profit (col C)]),all(Table))
Anonymous,
1) You should create a calculated measure as it will be dynamic in relation to any axes of analysis you want to apply.
2) You should use the divide () function, best solution to divide numbers without generating errors.
3) If you repeat the sam DAX formula, it is best to use a variable.
Example:
Measure = var DivideNumber = divide(sum('Table (2)'[Column1]),sum('Table (2)'[Column2])) return divide(DivideNumber,DivideNumber)
Anonymous - Is that really how your data looks? You can't refer to individual cells in DAX, you have to filter down from rows and columns.
