Adding measures and calculated columns

The table that has the burn down scope looks like this:

There's only one value for each project so I'm not clear as to why I need an aggregator?

---

Clint wrote:

Hello,

 

I am being asked to create a calculated RYG for each project and as part of that, I've created table that provides a KPI for scope (measuring how far over or under).  From this KPI, we generate a score using a calculated column

c_Scope Score =

SWITCH(

TRUE(),

'BurndownScope'[Ratio]<=1.3,1,

'BurndownScope'[Ratio]<=1.5,2,

'BurndownScope'[Ratio]>1.5,3

)

 

I then created a calculated column that adds the 4 components of the RYG together to generate an overall score.  The problem I'm running into is with the scope score.  Because it is a column, I can't add it w/o some sort of aggregator, which then gives me the wrong number for the overall score.  How do I pass the scope score for each project to the calculation for the Overall Project score?

 

Dax for overall project score metric

c_Overall Project Score =

'Risks'[m_Project Risk Score]

+

'Issues'[m_Project Issue Score]

+

'Projects'[M_Sched Perf]

+

'burndownscope'[c_Scope Score]

---