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.
Hi,
Merge the 2 tables into a single table with 3 columns.
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.