percent to column total

[sy_rock]

trying to get the daily percent of the pass to fail for the " NAME "  for each day, and then for each week, and month , year

exp. Jane 66.67 percent pass for 4/8/2017

Job ID 1 Job ID 2          Before          After          Status          Name          Date
xyz         xyz123          4743          4811             Pass                   Jane          4/8/2017 7:06
xyz         xyz124          2892          2869             Pass                  Jane          4/8/2017 7:11
xyz          xyz125          2784          2794             Pass                  Jane          4/8/2017 7:11
xyz          xyz126          3718          3799             Fail                 Jane          4/8/2017 7:11
xyz          xyz127          1800          1791          Pass                  Jane          4/8/2017 7:11
abc          abc123          547          557              Fail                   Jane          4/8/2017 7:16
abc          abc124          825          817             Pass                   Bob          4/8/2017 7:16

[v-huizhn-msft · Accepted solution]

Hi @sy_rock,

I try to reproduce your scenario and get expected result.

1. Create measure use the formula.

Pass-Percentage = DIVIDE(CALCULATE(COUNTA(Table3[Status]),FILTER(ALLEXCEPT(Table3,Table3[Date],Table3[Name]),Table3[Status]="Pass")),CALCULATE(COUNTA(Table3[Status]),ALLEXCEPT(Table3,Table3[Date],Table3[Name])))

2.Create a table visual, select Date, Name and measure as value level, please see the following screenshot.



3. The solution above calcuate the daily percent of the pass for the " NAME "  for each day. If you want to calcualte the fail, replace fail to pass in the formula. And then create several calculated columns, and replace the day to year, month and week.

Year = YEAR(Table3[Date])

Month = MONTH(Table3[Date])

Week = WEEKNUM(Table3[Date])

If you have other issues, please feel free to ask.

Best Regards,
Angelia