Forum Discussion

anshpalash's avatar
anshpalash
Helper II
4 years ago
Solved

Division Calculation by Week Number

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 ...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    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 )
johnt75's avatar
johnt75
Super User
4 years ago

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's avatar
anshpalash
Helper II
4 years ago

Thank you!