Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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 )
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 )
Thank you!
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |