Forum Discussion

anshpalash's avatar
anshpalash
Helper II
4 years ago
Solved

Division Calculation by Filters

Hi all,   I have a dataset similar to the form: Month Defect Code Defect Count 1 212 10 1 600 20 1 665 10 2 999 15 2 900 15 2 137 10   I want to calculate d...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago
    Create a column and paste this code 
     
    Column = DIVIDE('Table'[Defect Count],CALCULATE(SUM('Table'[Defect Count]), ALLEXCEPT('Table','Table'[Month])),0)
Anonymous's avatar
Anonymous
Not applicable
4 years ago
Create a column and paste this code 
 
Column = DIVIDE('Table'[Defect Count],CALCULATE(SUM('Table'[Defect Count]), ALLEXCEPT('Table','Table'[Month])),0)
anshpalash's avatar
anshpalash
Helper II
4 years ago

Thank you!