cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I

## Dividing Two Numbers

Hey folks,

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

1 ACCEPTED SOLUTION
Solution Sage

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.

see results below

I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!

6 REPLIES 6
Solution Sage

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]))``

I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!

Helper I

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

Solution Sage

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

I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!

Solution Sage

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

I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!

Helper I

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

Solution Sage

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.

see results below

I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!