Division Calculation by Week Number

[anshpalash]

Hi all,

I have a dataset in the format as follows:

Week Number	Defect Code	Defect Count
1	101	10
1	203	20
1	101	10
1	102	10
2	125	23
2	123	22
2	125	20

I am trying to calculate defect rate for a particular defect code by week. For example, the defect rate would be the total defect counts for that particular defect code divided by the total defect counts in that week. I want to plot a line graph where the axis would be week number, values would be defect rate and legend would be defect code. 

For example, in this case, defect rate for defect code 101 for week 1 would be (10+10)/(10+20+10+10) = 20/50 = 40%

Can anybody please guide me on how I can achieve similar calculation as above? Thank you!

[johnt75 · Accepted solution]

Create a measure as below

Defect Rate =
var currentCodeDefects = CALCULATE( SUM('Table'[Defect count]) )
var totalDefects = CALCULATE( SUM('Table'Defect count]), REMOVEFILTERS('Table'[Defect code]) )
return DIVIDE( currentCodeDefects, totalDefects )

[anshpalash]

Thank you!