Dividing Two Numbers

[Hudg16]

Hey folks, 

Trying to divide one value in a column by another not having any luck...

Thanks in advance!

[richbenmintz]

Hi @Hudg16 ,

Assuming you are creating a measure, the formula would look like

Avg New Activation Spend = Divide(sum(Data[New Activiation Spend]), sum(Data[New]))

[Hudg16]

@richbenmintz 

Not sure what I am missing here haha. I am expecting 500/2 = 250. 

[richbenmintz]

Hi @Hudg16 ,

Can u create two measures:

Act Spend = sum(Data[New Activiation Spend])
New Act = sum(Data[New])

then add those to the Matrix, would like to see the values they generate

[richbenmintz]

Hi @Hudg16 ,

Can you provide a link to a sample pbix file or sample data and a screen shot of your model, sample file would be best

[Hudg16]

@richbenmintz Pbix is attached, ive just narrowed it down to new in this case. Thanks for your help 
https://we.tl/t-zGeqYH87GO

[richbenmintz · Accepted solution]

Hi @Hudg16 ,

You will need to create this as a Measure, and not a calculated column, the calculated column is evaluated in the contex of each row in the underlying table rows, and each row has a [new] value of 1. In other words the spend on each row is being divided by 1 for each row when the column is created and when the model is processed, then the matric sums up the value in the already computed column value, nets to the same value as spend. The Measure will be evalutated in the context of the filter, query and visual. I am not likely providing a great explanation, here is are links to a couple good article for your review.

https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/ 

https://support.microsoft.com/en-us/office/context-in-dax-formulas-2728fae0-8309-45b6-9d32-1d600440a... 

see results below