Forum Discussion

Clint's avatar
Clint
Helper V
6 years ago

Adding measures and calculated columns

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 gen...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Clint 

What is the relationship amonth the four tables?

'Risks',Issues',Projects',burndownscope'
 
When adding four columns in one table visual, how does it look like?
'Risks'[m_Project Risk Score]
'Issues'[m_Project Issue Score]
'Projects'[M_Sched Perf]
'burndownscope'[c_Scope Score]
 

Could you give some data samples so that i can reproduce your problem?

 

Best Regards
Maggie

 

 

  • Clint's avatar
    Clint
    Helper V
    6 years ago

    Hi Maggie,

     

    Risk and Issues are related to the Projects Table via the ProjectID field.  The scope score is generated from a table that tracks the current scope and baseilne scope and is related to a table that tracks weekly burndown (and provides scope values) via the clarity ID in a many to one.  The Burdowns table is related to the Project Table via the Clarity ID (see embedded image).  This is a many to many relationship unfortunately.  

    I am using the "average" function to generate the overall project score in the Project Score table.

    Project Score

     

    Relationships