Forum Discussion

sprasad's avatar
sprasad
Helper II
7 years ago
Solved

Working with Custom Column

Hi,   1. I am trying to prepare a bug metrics to check the %age of bug has been fixed till now:   %age of Bug fixed is = Total no of Bugs in Closed State/ (Total bugs in Closed State+Total bugs i...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    sprasad  After performing the steps posted above, then create a new table as below

     

    Test187Final = SUMMARIZE(Test187,Test187[Project],"Custom",MAX(Test187[Custom]))

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

sprasad  Please try this as a new column in Modeling tab (DAX) instead of Power Query Editor.

 

Custom = 
VAR _ClosedProjectSum = CALCULATE(SUM(Test187[CountIssues]),FILTER(ALL(Test187),Test187[State]="Closed" && Test187[Project] = EARLIER(Test187[Project])))
VAR _AllProjectSum = CALCULATE(SUM(Test187[CountIssues]),FILTER(ALL(Test187),Test187[Project] = EARLIER(Test187[Project])))
RETURN (_ClosedProjectSum/_AllProjectSum ) * 100

 

 

sprasad's avatar
sprasad
Helper II
7 years ago

Thanks Manohar, It is working correctly. Can we display the %age calculated in Custom column in a single row for each project? 

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago

    sprasad  After performing the steps posted above, then create a new table as below

     

    Test187Final = SUMMARIZE(Test187,Test187[Project],"Custom",MAX(Test187[Custom]))