dax divide multiple columns

[Anonymous]

Hello, I would like to create a column Result. I wrote formulas into the column. 

Source	Price (col B)	Profit (col C)	Result
Facebook	2000	5000	108,70% (=C2/$C$6/(B2/$B$6))
Bing	3000	6000	86,96%
Google	2500	7000	121,74%
Twitter	2500	5000	86,96%
Total	10000	23000	100,00% (=C6/$C$6/(B6/$B$6))

Thanks for the advice

Tomas

[Greg_Deckler]

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

[Tahreem24 · Accepted solution]

@Anonymous ,

Please refer a screen shot attached:

[amitchandak]

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

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