Forum Discussion
Solved
Field values match, divide unique field value
I am trying put a curve measure on the Total Points measure, by dividing the Total Points by the City Name [Practice Group Count] on a seperate table. If City Names match Table1 with Table2 then divi...
- I answered my own question. I added measure on the Dimension Table, then another new measure dividing the [Points Total] by the new [Curve] meaure.Curve =CALCULATE(SUM(DimHandicap[PracticeGroupCount]))Total Points (Curve) =[Points Total]/[Curve]I appreciate all that took a look at this.
Good question, the Data table has 1000,s rows, the Points Total is calculating. Each with their own City. If I add the number I want to divide by on the data table, then I would have to use an average which opens up a rounding issue. I was only showing you the high level summary.
Adding more context, I want to add a new measure with the if the City Names match divide the respected number correlated to that City.