Forum Discussion

Fro88er's avatar
Fro88er
Icon for Helper IV rankHelper IV
5 years ago
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...
Need Help
  • Fro88er's avatar
    Fro88er
    5 years ago
    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.
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Merge the 2 tables into a single table with 3 columns.