Dividing Two Numbers

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-1d600440a7ad 

 

see results below